There’s nothing wrong with a bowl if it’s done properly. Old Trafford was after all, originally a bowl.
It’s just when they’re lazy, shallow tiered, miles from the action bowls that retain no atmosphere.
The Principality Stadium in Cardiff is a bowl and is imo, the best stadium in the world for atmosphere. La Bombanera is another often cited as having the world’s best atmosphere and that is 3 quarters of a bowl without even a roof.
At the end of the day, all the designing and engineering in the world can’t guarantee atmosphere if you don’t fill the place with the right people. The single biggest influence on atmosphere will be setting the ticket pricing and availability in the right place to fill it with die hard United fans as opposed to day trippers and corporate rubberneckers.