I find London & Rio worst with most setups. And for Rio, you better make sure you're wearing Adren Mod 3 too. London is also so boring because it mostly feels like the whole stage takes place on one level floor plane.
Vancouver doesn't seem to work that well enough with everything to be #1 DLC map (or at least I find Condor & Goddess to do handle more setups better). One funny thing in particular happened to me tossing homing nades from the highest spot toward a Ravager near the starting map point, only for it to hit the wall above. That made me face palm. 
Vancouver for me is right in the middle of well designed maps for the DLCs. It also looks great, so can't why you don't think it looks fine enough. It reminds me of that Shadow Broker DLC where you're flying through the city. And that's always a great feeling. 
Jade introduces some nice variety that works with well enough with any kit/setup.
And Hydra make more sense as a Volus (actually every stage makes more sense at Volus height.
I highly recommend because introduces to many more options to how you move around any map).
Goddess is a really great map too. Glad many like this map too, so I don't have to say anything about it.
Condor is so underrated because many just don't know how to move on this map. There's plenty of cover everywhere too, plus enough escape routes. This map has many different floor planes too. So much variety on this map. Looks really great too.