Mario Galaxy was excellent, but even I felt dizzy playing it sometimes. Mario World was excellent though, and I can't really think of anything bad about it. Mario 64 had some camera problems, but again it was excellent.
Zelda Link to the Past was my favourite of the Zelda series, that definitely won't change. Ocarina of Time best part was the horseman through the glass mirror, the rest was boring, bland and really showed the limitations of the cartridge format for me - no scenary etc..nothing to do.
Shenmue had great music and was interesting to play, but I thought it suffered from bad fighting mechanics.
But.. each person enjoys there game for many different reasons, such as the first game they played in the series etc..
I say each to there own.