Funny, I do quite a lot on a 30mpg (real world) Focus. Including haul bikes, go to lumber yards, etc.
The whole 'lifestyle' issue is moot. A smaller car occasionally hauling a small trailer is far more practical than any SUV.
While you may not have felt safe in the CRX, you are far more likely to get into an accident with those tall and heavy SUVs, and they are a threat to all other cars in terms of safety, especially in the winter.
It's amazing how people's mentality has been changed by auto makers, 17-21 mpg used to define a gas guzzler in the 80s, now its 'efficient', while the EPA ratings have little real-world significance. Truth is, fuel economy averages in all autos has gone down since the 80s, with profits going way up, especially for trucks.
Personally, I enjoy the thousands of dollars of fuel savings, insurance savings, safety and ease of parking of a smaller car. If it just happens that I'm less of a contributor to the pollution problem, ok.
My next car is likely to be a Mercedes Smart.