This sounds a lot like the 'we want a faster horse' quote attributed to Henry Ford. Yes, if space access gets significantly cheaper people will suddenly want to access space just like people did suddenly want to take aeroplanes to distant sunny destinations for a mere few weeks once that became somewhat affordable while before that going to those places was something you read about in adventure novels or National Geographic Magazine. Space hotels will become a thing for those who can afford it, maybe those 'giant wheels in the sky' will be built as well because someone like Musk thought 'why not?'.