Bastion: A (indie) action RPG this game is in my opinion a must play. Even though you said you don't like indie games, I think this is worth trying anyway. The game has an amazing story, soundtrack and voice acting. The combat is good as well and offers a fairly large ammount of diversity and customization.
Alan Wake: It's -90% @ steam right now so there is really no reason not to pick it up
I would say that it is a survival action game, arguably a survival horror game.
It's a really good PC port (probably one of the best). The game is kinda based around light and darkness, you can use your flashlight (and other light sources) to stun/dazzle enemys. You obviously need batteries for your flashlight and there are pages from alans book to be found which tells you a few things about the world etc... The game is kinda linear I guess but there are these pages and batteries to find so it's not on rails like CoD or any thing like that. It's really worth picking up for that price though. The writing is good, the characters are great and it's really atmospheric largley thanks to some really great sound effects.
Baldurs gate: Bioware's masterpiece. It is considered by many people to be one of the best rpg's ever. It has a solid story and is based in the D'n'D world "forgotten realms". There is a huge ammount of class customazion from fighter to wildmage to cleric. It is a fairly old game though so, you know, don't expect great looking graphics.
Darksiders 1 & 2: Is very similar to Zelda as said in the video. In the way that you get different weapons/gear and abilities to get to new areas etc etc... It's a fairly fun action rpg with an alright story.
When the Lamb opened the second seal, I heard the second living creature say, "Come and see!" Then another horse came out, a fiery red one. Its rider was given power to take peace from the earth and to make men slay each other. To him was given a large sword - Somewere in the bible :S
So yeah the game features the horsemen of the apocalypse and in the first game you play as the red rider, War. Well he basically did some stupid shit and brought about the end of the world to early, he then gets the chance to capture those who tricked him into it and thats basically what the game is about (read the steam thingy for more info if you'r interested). In the second game you get to play as the pale rider, Death. I haven't completed this game because my save files got corupted when I was almost done with it so you know, fuck it. Will we get a darksiders 3 & 4? Probably not...