Is a manual transmission more comfortable than an automatic transmission?

I've never driven an automatic. If the manual isn't fun unless you're revving high, and you have to shift at 2000 RPM, then don't buy this car.