Adventure will never die,
not on my watch.
But I know how you feel. I'm not that big of a FPS fan myself but the game I am playing most nowadays is Battlefield 2 MC (on ps2). I have been a computer and console gamer forever but I am not happy with the way either industries are going. I have no intentions whatsoever getting into the 7th gen of consoles. The DRE issues with PS2 being swept under the rug, the overpriced games/online services & downloads, and overall lack of anything jaw dropping in terms of gameplay innovation. This will be the true generation of gimmick, gloss, and developer buyouts. I believe that for these reasons computer gaming will have new opportunities but it will be on the people with our mindset and appreciation of the old to switch things up.
For now I enjoy going back and playing those (albeit often crap) games that wouldn't run on a 486, or that weren't affordable or easy to find. Not even playing them necessarily, but just reading about them and looking at screen shots or reviews is more appealing than trying something modern like Oblivion. That carries over into all aspects of entertainment for me...I watch more reruns and cable/on demand movies than I do new movies or shows. Same with music, I like looking up and listening to all the stuff that influenced my favorite bands rather than listen to them (who are defunct for the most part themselves). Its not that theres no good new music, its just that it doesn't hold my interest.