I work in infra engineering in such a company and it indeed is so mentally draining when something that should be a few clicks on Azure take me 2 days of chasing shadows to figure out what access I need and who to ask for it and then having to prove that I really need that access level and not a weaker one.
friend of mine few years ago was told by his manager to have a certain amount of points under the Java tag (and other related ones) for him to get promoted to senior developer. I remember him telling me he spent like 2 weeks just answering questions like 3-4 hours a day so he can show that he knows obscure Java stuff
I use it at work together with Azure Functions. Power Apps is great for small functionalities you need for Azure resources. My latest example is a logic app that triggers an Azure DevOps release. When I trigger this logic app via HTTP I also pass some parameters that the release definition expects.
Another example I made is to get Microsoft Forms answers that users submitted straight into a SQL Server DB. You literally cannot programmatically get the answers in any other way, by design. Its either logic app component or export to XLSX.
