Good if you have to sit in traffic.
Poor if you enjoy driving on open roads and in snow or wet conditions when braking through gears is preferable. Manuals make the roads come alive!!!
My car is auto, mrs P's is manual. We swap quite a lot.
Going to work (mostly motorway and heavy city traffic) - mine is infinitely more relaxing both at the start and end of the day. There's nothing fun about leaving work and instantly hitting traffic, but not having to fanny about with gears/clutch for an hour is one less thing to think about.
Long motorway journeys - not much in it, since you spend most of your time in one gear on the motorway anyway.
City driving - hers is way more fun, but mine is safer and more relaxing IMO. If I'm pulling out of a junction across both lanes, on a hill, in heavy traffic in the rain, it's nice to just put the foot down and go without my hands ever leaving the steering wheel. I find being stuck in traffic in my car more relaxing.
Weekly jaunts up north - this is where is gets interesting. Trips up the A82/A9 and further account for well over half of our overall mileage. On one hand, her car is so much more fun on bealach na ba, but it's also hard work on a 5 hour mostly B road/singletrack drive at 5pm on a Friday. My car isn't as fun, but given we do a 2-5 hour "engaging" drive every Friday evening and then have a packed weekend, mine tends to get me there a bit more relaxed and feeling fresher.
Snow/ice - hard one to call for me since my car is RWD/Auto but has snow tyres and hers is FWD/Manual and doesn't. I'd prefer to be in mine for the tyres, but it's nice to have more control over the gears in hers (although mine is tiptronic)
Overall - main word is "relaxing" i suppose. If you LOVE shifting because it makes you feel like you're a driving god, then i can understand how dull and pointless an auto must feel. But to me, shifting seems a bit pointless for about 75% plus of the mileage I do, and perhaps even an inconvenience for that 75%.
My plan is to buy something cheap and quick (350z etc) for those days when I feel like I just have to make the roads come alive