Personally I'll always prefer manual, not only for the fun, but because it makes me feel that I have the control of the car.
The automatic feels... well,

is "automatic", you don't have control, and when you turn it to the "manual" mode the gear change doesn't feel like "real" gear change, it feels like you press a button on a computer and the gear changes.
Despite that, the automatic is a lot more relaxing especially for the everyday, city/traffic drives.
If I had this luxury I would choose an automatic car for the everyday jobs and a manual car for the weekends

(but if I had to choose only one car I would go for manual)