DjMizuhara is not the kind to waste any time so here is a video of the demo of Vanquish on Playstation 3. A good opportunity for you to find out if there is anything you see that you like before you can give it a try yourself.
@GriftGFX: The issue with what you suggest is they are FPS games and or MP, not my cup of tea. I am talking about SP games: adventure/action/horror. Where are the hard Ninja Gaidens, Dragon Quests (34 minutes ago)