I was initially an Automatic Hater (😬) after driving some entry level automatics (Some Maruti AMTs and an old i20). All the cars in my family had been manuals too.
But it was when my friend bought a Polo GT that I experienced the driving pleasure offered by DCTs. My current car is a DCT. Shifts are quick and butter smooth, unless we floor the throttle, we won't be able to feel gear shifts even when we're trying to.
Volkswagen (and Skoda) DCTs are notorious for failure after a few years though.
Take some long test drives, in traffic, highways, turns, hills, mild/sporty driving, overtakes, etc and you'll clearly see the difference between all of them.
Unless you're a pure driving enthusiast, transmission type might not be the best factor when choosing your next car. And there's always electric with no transmission 😂.
Also check out reviews at teamBHP.