I've been reading the operating and performance manuals on the E190 and there's significant restrictions operating it out of London City. With a full passenger load it'll go about 700 miles (which is Madrid or Stockholm), then for every extra 100 nm you need to leave 4-5 seats empty. So if you want to reach Portugal, Southern Spain or Central Italy you'll need to restrict to around 88 passengers (from 97). The complexities of this I'll go through below for those who are interested:
The operating empty weight (OEW/BOW) is around 27900 kg for the AR, LR or STD E190 variants; I can't find figures for the SR Short Range version that is often used at London City, but apparently it's not structurally much different although it has a far lower MTOW likely to reduce airport fees.
On London City's 1200m runway the MTOW is approximately 42000 kg using Flap 4 in ISA conditions, with the uprated "E7" engine software coupled to ATTCS that will overboost from 18500 lbf to 20000 lbf in the event of single engine operation (the normal CF34-10E6 won't overboost thus reducing MTOW to an almost useless 39750 kg).
With 97 passengers in two classes and 1200 kg in the hold, you have a total payload of 9500 kg. That leaves you 4500 kg for fuel before you hit MTOW for LCY's short runway, which gives a range of around 700 nm. If you want to go any further then you have to start reducing payload so you can add fuel. Restricting from 97 to 88 passengers gets you to 900 nm range. But BA Cityflyer operate their E190SR much further than that, 1630nm to Santorini in Greece! Whilst their SR's OEW/BOW could be lower, I suspect BA are simply restricting passenger loading to around 65% for sufficient range!
So I hear you asking about the smaller E175 which is 22 seats smaller and thus significantly lighter when empty so should have more useful load and require less fuel. And that would be the case except the E175 engines' have a physically smaller fan and are thus 4000 lbf down on thurst per engine, which means the MTOW out of LCY is also quite a bit lower then the E195, so there isn't really a net gain and you're lumped with an aircraft that's then very similarly sized to the Q400.
I expect the V speeds would also be lower with the "E7" engine variant when you're MTOW limited as you're relying on the "overboost" function to get you out of trouble if you have an engine failure.
The CSeries has a much higher usable payload from London City, indeed one has already flown non-stop transatlantic to JFK carrying the equivalent of 40 passengers! Unfortunately doesn't seem a good one will be forthcoming for P3D any time soon.