Night Terror is spectacularly well done but is really meant as a campaign map. Heaven Can Wait is one of my favorites as well. That one is good either vs or campaign.
Yeah, thats a rough one. Best to usually find a spot, shoot every car you can, move up, repeat ad nauseum, or....just haul ass. The hauling ass part is swell if you have a pipe. If not...not so great.
You can also drop down into the stairwell from up above and pass a couple levels. Helps out a bunch.