They did this Luigi's Mansion 2 as well with the quick start n drop missions, it wasn't to bad then even if the missions were all alike across the mansions but this is far worse, it's meant to be a hotel but what the hell kind of hotel has messed resevoirs or each floor seperate to fit a seperate biome? For that matter why are there no stairs between floors?
But for real the thing that really bugs me is how randomly the place is set up you literally have stage magicians a floor above an egyptian pyramid.
It's such a simple thing but having no stairs to connect floors really broke my immersion, I think they got 'haunted' confused with 'magic' and said 'good enough'.
It's nice that all the floors are different but it's so difficult to actually buy into the fantasy with the floors being different sizes on top of each other, as if every floor uses Time Lord science or something.
The order of things really feels thrown together too, like you said, magicians above a pyramid, etc.