@sotto123 - I'd never played a resident evil game before and the first 20 minutes of RE4 were amazing. It just keeps getting better. It definitely can be scary so if you're young or don't like scary stuff I'd suggest one of the others. I've heard great things about Bully. Some people say NMH is sweet, some don't like it as much.
@Dbomb - For VC I'd suggest Zelda OoT, Super Metroid, Mario 64, or Pokemon Snap. There's also the DK Country games.