I don't personally have experience with a diverse multitude of cars (and transmissions) as a whole either, but i've heard plenty of good things online about the zf8 as probably one of the best torque converter automatics on the market for sporty driving (e.g. having very responsive shifts). It supposedly does not feel like a "slush box" which i'm assuming exhibits many of the behaviors that you're describing for a typical torque converter automatic.

In terms of drivetrain choices for daily driving, fully electric bevs seem to be the best fit. Instant torque, lots of torque, probably lower maintenance(?). And i say this as a lover of manual transmissions (my miata is currently in the shop though 😢)