try RE4. you can get a gamecube for $30 now if you don't have one.

i couldn't put them in order but i think my top three are RE4, FF7, and MGS3. cs source and halo are gonna be pissed, but those games were made by multiplayer, not the campaign like the first three. half life 2 was pretty killer, though.