That feature has always been annoying to me, even on phones. I always turn it off because "I" will control whether my screen rotates or not. Maybe sometimes I don't want it to rotate when I turn the phone (like when I'm viewing building plans at work and want to orient the screen with how I'm looking at the building I'm standing in).
Not sure how standard this is, but on Pixel phones the default is no auto rotation, but when the phone detects rotation it will display a tiny rotate button in the corner of the screen for just a few seconds. Best of both worlds IMO.
On Samsung devices you can go into settings and add a "routine" under Modes And Routines that automatically enables auto rotate for certain apps, and disables it when you leave the apps.
Alternatively I believe you can do the same if you have a license for Tasker.