Looking for a crossover-hybrid-sports car handling vehicle

I’m looking for a new vehicle - $30,000 or less - one that offers a manual tranny with V-6 or turbo-4 power, gets at least 30 mpgs on the highway, seats 4 adults comfortably, can haul camping stuff and a couple of kids, but cleans up well for a night on the town and looks edgy. I’ve look at the Ford Edge, Subaru Forrester, Mazda CX-7, maybe Ford Escape (though I am not really an SUV fan). Manual tranny and 30 mpgs are a requirement.





Any suggestions?