The Azure/Octopus paradigm is making it too easy to add yet another gate where yet another approver has to sign off in my opinion.

There are a lot of chokepoints in this space. The art of always needing someone to approve a pull request for every commit leads to some hacky horseplay in which pull requests are just ceremonially approved without even a look over as everyone is frustrated with the overemphasis on process and numb to it. Also the ability to loop in another team for oversight for approvals in as granular a level as schema and permissions changes at a Visual Studio Database project but not, for example, stored procedure changes empowers just that leading to too many cooks in the kitchen and a slowness in getting anything done. You may make a Rube Goldberg machine to roll your code out with.