I'm looking through my drive now so you might see this post get edited several times in the next few minutes. Other non big name titles that I think are awesome:
Broken Sword: The Shadow of the Templars
Metal Slug Anthology
ObsCure: The Aftermath
Tenchu: Shadow Assassins
Harvey Birdman: Attorney at Law
Destroy All Humans! Big Willy Unleashed
Those are probably all of my favorites that i don't hear mentioned all of the time like the big name Nintendo titles. If I can think of others I'll add them later. I kind of was scanning my drive pretty fast as it's almost bed time for me.