I hate using manual mode in an automatic. I love driving stick. The fun in driving stick isn't from being able to pick gears.
My feeling is the opposite. Paddle shifters are the closest I'll get to driving an F1 car, and I've put a decent amount of time in with a racing wheel and pedals and racing sims and that's where I get all of my muscle memory for my Golf GTI.
There's no point revving out all my gears in real world driving, I just want to reach the speed limit as fast as possible then go into overdrive. DCTs are very fast at switching into what they think is your next gear. They're quite slow at switching if you want to switch more gears.
Given the low end for 6th is around 35mph, 2-6 is plenty doable without going anywhere near redline.