Are the new civics 2012 actually ok for acceleration?
Define "OK".
The average person in traffic takes at least 15 seconds to reach 100 km/h and often more than 20, and that's no matter how powerful the car is that they drive. I've never owned a car that had more than 120-ish horsepower and I've put the better part of 800,000 km on VW diesels, which are hardly examples of blistering performance, and I've never had an issue keeping up with traffic. All modern cars are "OK for acceleration". Period.
Whether you
want more than 90 horsepower in a 3300 lb car (that's what my Passat TDI was) is quite another matter, but to stay with traffic, you don't
need it. That 90-horse Passat TDI towed many a motorcycle trailer with two bikes on it to Deals Gap and back.
The main issue with a good many cars is not that they are short on power, but that they are geared reeeeeally tall in the interest of fuel economy, and the transmission upshifts to a high gear as soon as possible in the interest of fuel economy. The diesels do better here; they're still geared tall, but 100 km/h in top gear in a VW TDI has it running at 2000 rpm give or take, and that's right where the torque peak is, so you don't get the typical gas-engine feeling of nothing happening when you step on the accelerator.
The current Civic is two generations past your 2004 model. But they're still tall-geared four-bangers. It will scoot ... but it will take revs in order to do it. The engine is a smidge bigger (1.8 versus 1.7) but I'm sure the car has gained weight. Every gas-engine small car short of the performance-oriented models (VW GTI, Ford Focus ST, Civic SI) is more or less like this. But the performance-oriented models don't get the gas mileage ...
It sounds like you have your mind set on Honda/Toyota. No sense asking us, then. Quite a number of us have told you what the current best-in-class vehicle is, and it's the Ford Focus!
P.S. I'm back home. The Focus got around 37 mpg US (6.4 L/100 km) with me driving it, suburban-type driving.