ZPavelZ: I think one big franchise that is still remaining sustainably good is arguably Warhammer 40k series. Dawn of War II was still alright and I actually enjoyed demoing Space Marine via OnLive.
orcishgamer: I was playing Space Marine last night, in fact, I don't see how anyone can complain about how that game turned out (perhaps they screwed up some of the lore, dunno, I'm not a big 40k lore guy, I just kind of dig the visuals and the atmosphere).
I do contend that these franchises aren't "screwed up", some of them just have bad games. RE4 ended up good, and then they went back to fucking up the games, eventually they'll get another good one in there. It's a little early to be calling Max Payne a dud, watching some of the gun play videos it looked like engaging gameplay to me.
Space Marine was good for consoles... For PC not that good.
For screwed franchises: Age Of Empires,SimCity,Worms,Max Payne(If we count it as franchise),NFS Series and this list is quite long.
Max Payne is screwed up as an idea... The game will look nice,will probably be nice to play,but yet that is not Max Payne...