Basically, I'm starting to tire from building units and killing hordes of enemies. What I'm looking for is a great game storyline I can play before bed. Games I have considered to have the best storylines that I have played are

God of War I + II
MGS series
Zelda
Kingdom Hearts
FFX

And I'm wading my way through Oblivion. Any nice additions or game suggestions will be appreciated.

If you have a 360 get Lost Odyssey and don't give it a second thought. It has the best storyline of any current gen game.

Also give The Legend of Dragoon (PS1) and any Breath of Fire (SNES, SNESGBA, PS1, PS2, PSP) a go. Personally I think BoF IV is the best one.

Well I just bought The House Of The Dead 2 & 3 Return for the Wii, that should be fun and mindless zombie blasting. Pretty awesome storyline there.