Well, see, to me, when a song doesn't settle on anything long enough for me to get a musical response from it, that tells me that chaos is the whole point. Like, you've talked about Metropolis before as an example of a song with crazy jarring transitions, but to me, Metropolis is a song about crazy jarring transitions. The first time I heard that song I thought it was completely batshit insane. Luckily it was intriguing enough to make me listen again, and by the fourth or fifth listen I was acclimated to the chaos of it, and nowadays I adore every chaotic moment of it.
It's sort of like spinning around in circles. Sometimes, spinning around in circles can be very fun. But if your goal is to get somewhere, then spinning around in circles is just a meaningless waste of time.
So to me, a song with lots of crazy tiny sections is like spinning around in circles for the fun of it, whereas a cohesive song with one large crazy section pasted in the middle of it feels more like trying to get from point A to point B and randomly stopping to spin in circles on the way there.