Cube > N64
Now the N64 was disappointing compared to the AAA+ SNES.
I actually thought the Cube gave me much of what I was missing on 64... Metroid, mature games (RE, MGS Twin Snakes), actual RPGs (Skies of Arcadia).....
Anyone who thought they could buy a Cube alone and thought it should be like its own PS2 were probably disappointed, but those who bought Cube as a second console shouldn't have a reason to complain.
I got more great Nintendo games on Cube than I had on 64, and I even got a handful of great third party gems as well. To me that was a success.
I never experienced the "drought" that people talk about, though I remember it on N64 and I didn't even put much hope in that console. Then again, I think having one good game every two month or so is fine.... any more than that and I can't keep up!