I've worked at places where senior devs have access to prod for emergency fixes but usually the procedure is to use a VPN AND an ssh key with a passphrase. Usually.

Startups and small companies where there simply aren’t enough resources to set up proper operational controls

I've worked at several places where I've been able to access production databases.

No need to be so dramatic about it, really.