Having used both the Flybe Embraer E195 and the Q400 this year to FAO and LCY this year from CWL whilst being very different I quite enjoyed both aircraft, although on passenger expierence I'd certainly recommend The E195 to travel on, leg room being very efficient over locos that I've used , quiet when compared to other jets and a very comfortable Journey. You'll often see passengers opting for other airports if a Turboprop aircraft was operating a particular route, just for example Ryanair picked up a lot of Welsh travellers because of the EI operating from Cardiff on the ATR, BE now operate a jet service on that route and also from DSA I believe.
I'd tend to agree with Local, the Q400 is fine for short hop regional travel, I myself was sat in row 18 travelling to LCY and they aren't the quietest in the world towards the back, I'd describe it as a lawnmower drone in all honesty, the overhead bins are also extremely small, Business people taking those walk on cases will not get those in. Would I want to travel on a Dash8 over a jet to any destination outside the UK ? I'd probably say no
A little off topic but I remember using the Aer lingus ATR from CWL a few years ago and the aircraft that I flew on in the morning was leased from DAT, safe to say the aircraft was a complete mess inside, chairs ripped and a quite odd configuration inside, flight was pretty awful and I could see why people could be put off, happened to be a new ATR-72 on the way back and the difference was just staggering.
At the end of the day it comes down to what a traveller is comfortable with, you'll have some who won't even contemplate using a Turboprop and others who won't seem to mind what they travel on.