I think we're in safe hands when it comes to creating a destination. To quote Jurgen Klopp loosely - "them Arabs know what they're doing". We'll be well aware of the development potential and the ability to cash in on the Coop Arena and create a range of restaurant/cafe/entertainment facilities which, alongside hotels, will attract larger numbers of visitors.
It's not the most attractive place in the world, but a good quality block paving, some tree-planting and a range of covered outdoor and indoor bars/restaurants will instantly improve things.
As for the North Stand expansion itself, I still hold out hope for a home end with a single tier or two tiers, but I remain doubtful. Having said that, the club will want to keep growing and realistically the side stands are where you can maximise hospitality revenue. People want to be side on to the game if they're spending big money, not behind a goal. I do believe the East and Colin Bell will be expanded in the future and as a result the stadium will be much more atmospheric. If the club did nothing other than changed the roof angle it would instantly improve atmosphere. You'd end up with a roof that wraps around the bowl and retains noise and it would be spectacular. The corners have been designed to be removable and you can see from the South Stand expansion how that could tie in along the sides. We're miles off that yet but shouldn't panic too much if we don't get a single tier. Spurs isn't particularly loud despite having one and the Etihad has been rocking for plenty of games despite not being designed to retain noise.