sure, but there is a tradeoff between performance and fuel efficiency: your sports car crusing along at 3000rpm is sucking fuel to do it. i think being programmed for efficiency is a reasonable default, and sport mode available when you need/want it. of course soon enough any differences in ICE transmissions will be moot..
Except it isn't. You'd think that 30 year old engine technology, combined with double the rpm would use hugely more fuel, but in practice it's not that big of a difference. What has changed is that manufacturers have figured out that nobody makes a buying decision on the nonquantifiable driving characteristics that auto magazines used to describe, and therefore it's a no-brainer to sacrifice them for 1 or 2 mpg more.
And of course, the newer SUV gets much worse mileage anyway. If a couple mpg really matters that much to you, you can always drive less too. The earth doesn't care if you get twice the mileage or drive half as much.
Also, modern automatics tend to change their behavior all the time according to mood. There is nothing more counterproductive than an "adaptive" transmission (or other system). The word "adaptive" simply means that it isn't responsive when you do something different. Which is bad.