While it's far from the worst cultural shift in TTRPGs, it really is a shame how much the mainstream standard for prewritten adventures has shifted from short adventure modules to massive hardcover campaigns.
Short modules are just so much better for the types of adventures that most mainstream TTRPGs are good at: you arrive at a place, it's Weird, you meet some cool people, it turns out there's a fucked up little situation going on, you get involved and blow up the situation in whatever way best suits your characters, and then The Adventure Continues. Depending on what happened in the adventure, the GM might decide to bring elements of it back in the future: NPCs you vibed with (or hated), places that you made a connection with, elements of the situation you left unresolved, whatever. Or not! No pressure, because the next adventure is going to be a new weird place with a new fucked up little situation.
Long campaigns, by contrast, constantly need to constrain the players so that they can keep the campaign relatively coherent. Even the ones that work hard not to railroad the players have to limit their ability to impact things so that the players don't somehow avert chapter 10 by doing something way back in chapter 3. And often, this results in very weak connective tissue throughout the adventure, with the character mainly doing what they are told by NPCs who are the ones with the real stake in things. After all, how can the PCs be the main characters when the adventure must be written with no idea of who they are?
And then this in turn feeds this culture where, actually, the Good GM homebrews their own campaign. That way they can actually center the PCs, and not railroad them, and throw out everything they prepped when the PCs refuse to engage with plot hooks and do completely unrelated stuff, because that is the opposite of running the big boxed adventure.
But actually, incorporating the creativity of other writers into your game is great. You can get so much mileage from taking someone else's fucked up little situation and tweaking one or two things to put it in your campaign. You can center the PCs so much when you don't need to protect future story arcs, you can just throw them in the mix and let them do main character shit. It's great.
Most importantly, though, I think more people should be able to have the brain chemistry-altering experience of not knowing what you're going to run next week, and being in the local game shop browsing shelves of dozens of fucked up little situations with some Brom-ass art on the covers and mostly terrible writing peppered with ideas that will stay in your brain forever.