Well, for having previously owned an Integra GSR and currently owning an S2000, two cars with arguably some of the best acting manual gearboxes ever made... I love dual-clutch gearboxes, and find them more fun on
both street and track settings. It's g-forces and the changes thereof that that really get my adrenaline. Executing a gear shift change, something I can do in a garage with a turned off car with manual gearbox, just really isn't interesting in and of itself. Some of my most exciting motorsports activities have been in a single-speed kart.
Traditional slush-box transmissions like you'd get in a typical rental car are indeed horrific to me - slow, mushy, nauseatingly disconnecting the engine from the wheels. Manual gearboxes are vastly superior to them, in my opinion. There's the direct connection between throttle, engine and tires. There's the immediate response of physically moving bits around. Everything is immediate and connected. And dual-clutch gearboxes now have those qualities as well. (Even some TC gearboxes like ZF's 8HP used in BMWs and such.)
The act of moving a manual gear shift knob and a dual-clutch gear shift level are essentially the same except for a minor difference feel (switch vs rods vs cables.) Adding a 3rd pedal doesn't change things - for example, installing a 3rd pedal in dual-clutch cars that acts as a lockout preventing shifts unless it's pressed would bring nothing to the table in terms of fun for me even though it would get pretty close to mirroring the manual gearbox experience. Also, the fact that properly shifting a manual is more difficult doesn't make the drive more enjoyable for me either - just like having a badly handling, and therefore more difficult to drive, car isn't more enjoyable than a well balanced handling car.
Anyway, just my view on it, not trying to convince anybody that my view is the Only One True view.