Looking for good shooter with a single player able survival mode - General

I'm looking for games that feature arena modes with big maps where you survive waves of enemies and are rewarded in some way you can control by either surviving waves and/or killing enemies, then selecting new weapons and upgrades yourself. That in itself is quite a broad definition and you don't know what games I'm currently looking at, or which games I've played and loved. I've played the shit out of killing floor but that game isn't much fun played alone and honestly in the end has numerious glaring flaws like uninteresting bullet sponge enemies and shitty maps. I've also played the shit out of sniper elite V2. Only 3 maps and only 2 are really even servicable and only one of the maps has more than one decent sniper's nest. On top of that the only satisfaction that comes from it is the killcam which isn't well implimented (considering it's the only thing that gets amusing after a while you'd think they'd make every kill an x-ray). Also nothing is gained from killing enemies besides a few things which you can loot. The amount of items and weapons at your disposal is just as underwhelming as the maps. It's great fun but the shitty maps and lack of some sort of at least single session improvement/reward system make for a fairly hit or miss experience in the end. Then comes along splinter cell blacklist. Charlie's 4E missions are basically one of the greatest things inside of this game. You get money for completing challenges and missions which you can then in turn use in the metagame to buy and upgrade guns/gadgets and your support system. That then gets carried on to whatever mission you are playing. Not only that but you can swap gadgets and weapons in game. Aside from the abysmal selection of not exactly great maps (they're all a bit small) and kind of unsatisfying shooting mechanics this is the best wave surivival I've played so far. I heard Call of Duty has good wave survival (currently eyebanging Black ops 2 and MW3) as well as Rainbow Six Vegas 2. I'm looking for wave survival with satisfying shooting, big detailed maps and some sort of character progression system, even if the character progression is limited to ingame and isn't meta like Blacklist.

MW3 pretty much fits your bill. Everyone around here hates on MW3 but don't listen to them, it's a good shooter and is pretty much exactly what you are looking for.

iirc Max Payne 3 has a great survival-esque mode or has one in one of the DLC's. The gunplay is great and the maps are nice, but I'm not sure if it has any progression.

Dead men walking only has 2 maps sadly. Also to play it solo you need to do a hacky workaround.

I want to see the day of fully destructible environments with reasonably realistic destruction physics in games. Imagine survival against enemies in a crumbling castle and stuff.

Are there any mods for the Crysis series that have wave survival on a giant island with the suit? Or at least something vaguely similar to that, not necessarily a mod for crysis?