While I'd rather have a manual transmission in a car, the 7 speed dual clutch transmission in the Allroad works great. My only issue with it is the need to replace the fluid every 40k miles. Audi's are great cars but you definitely need to be diligent with the scheduled maintenance.
I can't speak to the long term reliability of Audi's mild hybrid system. It's only been in A4's since the 2021 model year. I imagine it will be a lot like Ram's etorque system reliability because of the similarities between them.
I'm with you regarding the CVT. That would drive me bonkers even with Subaru trying to mimic it having actual "gears". I've owned two Subaru's in the past, both WRX's. Fun cars but not the best for longer drives. In 2020 I rented an Outback for a week. I absolutely hated it. You might want to try renting one before committing to buying one.