Classic Controllers are far from pointless, I agree. In fact, I much prefer to use the Classic Controller. The Wavebird is a lovely pad, but useless in Street Fighter II, and I can imagine many games. Bought a second one today so my bro can't blame the Wavebird for me kicking his bum.
I think IGN noted that it was more comfortable to play LttP with the CC - although that makes sense as the CC is a SNES-based pad.
/EDIT: I bought those two games second hand for about £12 around a year ago. Top titles, still nice graphics even now.