Well I'm a drummer of 17 odd years and I still find a 4 piece more fun to play on than a 9 piece.
With a 4 piece you have to get more creative and with 7 toms all you seem to want to do is just roll around on them til the cows go home.
True, if you're Keith Moon.
Then again, I grew up learning from Neil Peart, Mike Portnoy, Phil Collins...and it seemed a lot of those kinds of drummers started with huge kits just wanting to roll all over the toms, but some ended up using them more for groove and more clever fills, so as a drummer of 15 years, I've gone from "OMG rollzzzzz down the toms" kind of drumming to using them in more thoughtful fills and grooves. It's just for different sounds and how one can creatively employ them.
I have also drummed of kits that were just a bass drum, snare, hi-hat, one crash-ride and 2 splashes. THAT was a lot of fun. Having no toms made it especially interesting, using the cymbals for more fills and effects, and employing different techniques on the snare.
I don't think the size of the kit should have ANY bearing on a drummers abilities or creativity. The drummer themselves has to prove that, and if they can play on ANY kind of kit, then they have reached a certain high level of talent and ability in my eyes. If you can cover "Tom Sawyer" on a 4-piece and make it sound good, that's AWESOME...and if you can cover a simple jazz standard on a 15-piece double-bass kit and make it sound tasteful, more power to you!
To me, the best drummers have always been those who can adapt and blend to what's in front of them, both drums and the sound/style they're playing in - not ones who are super-fast, or can do multi-limb poly-rhythmic grooves...it's the ones who can do a bit of everything. One-trick-ponies only have one trick, after all.
And going back to Keith - he was a Celebrity as much as he was a Drummer, and so I think his spotlight grew because of who he was, not just because of his drumming. Then again, back in the day, musicians loved and lived the spotlight, so many took it and held on as long as they could....even if that time ended up tragically short.
-Marc.