There's Silent Hill 3, a good scary one.
Amplitude, a good music one.
I hate RPG's unless they're on a handheld, so I can't help you there.
Get Jak 2, True Crime: Streets Of L.A. or Viewtiful Joe.
I played the demo for Viewtiful Joe. The game is fucking crazy.