See, the simple fact is V6 usually gives you a more powerful drive, at the cost of a large increase in gas consumption.
Of course, the acceleration you feel will also depend on the weight of the car.
Is this your first car? If so, I'd recommend a fuel efficient small car for easier parking and less likelihood to speed.
But again, it felt much better when I tried an SLK than what I am driving now =D