Do CRJs stink? Yes.
Solution? Move to a real city. Simple as that. At the end of the day, I'd rather be able to fly to a place like ITH or CHS (my last two CRJ destinations) with some measure of frequency than have the airport see zero or infrequent service.
As for the Q400... Death trap. Simple as that. Not at all interested in flying them.