I've had two 6 spd manuals. One TT BPU and now 600BHP single. I love the manual box. It is a little agricultural, but then it can handle some serious power. On my current car I find slow moving traffic hard work, the first and second gear rev out quickly and I end up working the gears quite a bit. I believe my biggest issue here though is the heavy RPS clutch I have.
I have had the pleasure of driving a friends UK TT BPU auto and have to say I was very impressed. I think generally an auto BPU is a better responding car, certainly a more refined drive.
I've not been in a single turbo auto, but I assume the same is still true.
I think how the car is setup is very important to the feel of either the manual or auto experience.