Two that spring to mind for me are Red Faction: Guerilla and War Hammer 40k: Space Marine.
RF:G was by no means a perfect multiplayer game, but it was massively fun, setting up elaborate destruction traps to force bottlenecks on your enemies, or pull them all into one area and use gravity grenades to pull 3 building onto them. With the right people, there became a hugely tactical element to what should have been a lacklustre tack-on to an already great game.
W40k:SM, was insanely fun to play. It absolutely should not have worked as well as it did. The seemingly unwieldiness of the Marine at times, actually gave weight to how huge and heavy they're supposed to be in the lore of the universe, and actually meant players had to 'git gud' to do well.
I'd love to see the City of Leeds used as a location. The city centre is a good mix of mutliple levels, shopping centres and back alleys. The multi-cultural University campuses, oriental district and the largest covered market in Europe are always teeming with people.
Plus it would be great seeing the Americans try and understand a thick Leeds accent.
Sunken area, with all the coloured water: (Non-spoilery screeshot here.)
Where the red water is, down the stairs; the last panel, with the tetrominoes and the subtraction squares. I just can't crack the path without excluding one subtractor. I've been stuck here for three hours now.
Never mind, came back like an hour later and cracked it instantly.