I like this idea. It does need to be a system-wide thing really, and while this does add a bit of settings and UI clutter it’s a common enough problem that Apple should be doing something to address it.
It might actually reduce clutter, since plenty of apps are now individually adding rotation options to their settings. Having a system-wide setting would simply consolidate all of these in one place.
