WoW: Wrath of the Lich King will have new fire effects!
Seriously though, Fallout 3, Mass Effect, Stalker: Clear Sky, Tiberium, Starcraft 2, Spore, Empire Total War, HL Ep3, Warhammer Online, Left 4 Dead and possibly Alan Wake are some of many. Sure, I doubt most of them will push your system, but why is that a must? Surely if the games are fun, look gorgeous and run flawlessly, wouldn't that be better than a game that your computer struggles to run well?
Anyway, PC gaming isn't in a slump at all. I am looking forward to many titles, and those are just the games that I think I'll enjoy. There are many other titles that I don't know much about or don't care bout that will be released soon, but they may well interest others, so there should be something for every type of gamer to look forward too. But if you really want something to look forward to that will push your PC, look for info on Crysis: Warhead that has just been announced. That should keep ya happy.