I really enjoyed Viva Piniata and Kameo! Both were extremely high quality.
What is amazing about Viva Piniata was that my retired mom (afraid of turning on the computer) got interested seeing me play and started playing herself! She ended up unlocking every single feature/award in the game, and this led her to play other Animal Crossing on the GameCube. I got her the first iPad when it came out and she is now essentially a regular computer user! While Viva Piniata might not have been a commercial success, I know one life it changed and I'd bet there are a lot more.
Frankly, I wish the world had more daring developers/game companies/people. The situation with Rare isn't a good one as your quip points out. Sadly, no matter how artistically awesome your games are, without commercial success, you cannot survive. This leads to a world of xbox games where pretty much every game is a shooter. IMHO, that is why tablets are kicking console gamings behind. It seems more creative titles for tablets (and perhaps the indie game section of xbox live) than for the xbox today.
GoldenEye 64, Blast Corps, Donkey Kong Country, Killer Instinct, Banjo-Kazooie, and Perfect Dark.
After MS buyout?