It's called "engine brake" and the fuel consumption is 0 in spite of the revs.
As far as mileage goes, my experience in modern cars is still the opposite, manuals still use less fuel.
for anyone else seeing this that is interested, here is a video: https://www.youtube.com/watch?v=mm6SSeLivqE
I didn't notice this auto-revving behavior, however. I was driving a Ford in England, so maybe they don't have this "feature."
Automatics nowadays are very good and pleasant.
https://www.autocar.co.uk/car-news/new-cars/analysis-are-man...