Which scare screens? I've sideloaded on Android for nearly a decade now, and the only one I've seen is the reasonable warning about third-party app sources when enabling it for the first time.
There weren't scare screens, at least I don't remember any, but the upgrade flow was comically bad for apps installed outside of the Play Store.
Let's say you install 15 apps on F-Droid. Every time you want to upgrade your apps, you were forced to manually initiate, and then sit through, each app update as they're installed in the foreground. This was because of deliberate limitations in Android.
Whereas on the Play Store, you could hit one button to update all of your installed apps and the installations happened in the background.
I believe it was after Google was threatened with lawsuits that they modified Android to be less tedious when it comes to managing and upgrading apps outside of the Play Store.
I believe the right thing I wanted to refer to is unattended app updates, enabled for third party sideloaded stores only with Android 12 or so. Maybe 12 added it back after it was taken away at some earlier point?
I am an Android user for a long time (since Android 2.2) and used pretty much every version from then on. Google devices (from Nexus to Android One devices and now Pixels) pretty much always allowed unattended updates for a long time (you may be right about Android 12, my memory is fuzzy here). And I never remember having scary warnings for sideloaded apps, sure, Android made it more difficult to install them (by having a permission per app instead a global permission, but I would say this was a very welcome change), but it was never convoluted or difficult.
But yes, non-Google devices make this way more difficult, e.g.: Xiaomi devices actually has a scary warnings and they trigger at each reinstall. Also, they messed up something in the install APIs so you can't update apps unattended, needing to trigger the popup to install at each update.
So yes, in general, this is not the fault of Google but third-party companies.
I think what people upthread are talking about is allowing third-party stores (like F-Droid) to do unattended updates. That has not been possible until recently. Up until Android 12 or so (possibly later), I had to manually approve it any time F-Droid wanted to update an app I'd installed through F-Droid itself.
Unlike with apps installed via the Play Store, which can update them without needing my manual approval.
