I should point out that the reason I'm "getting tired" of the long campaigns is because I've run a LOT of them. I've done Out of the Abyss and Dragon Heist twice each, I've run half of Tomb of Annihilation, half of Storm King's Thunder, all of Elemental Evil, half of Baldur's Gate, the first level of Dungeon of the Mad Mage, Horde of the Dragon Queen and half of Rise of Tiamat.... what am I missing?
And as a player, I've played Icewind Dale, Storm King's Thunder, Tomb of Annihilation, and Curse of Strahd.
As you can tell by the above list... I don't always finish them. They're too long! I prefer the length of Lost Mine of Phandelver, which I've run twice. I've run a little of Candlekeep and Saltmarsh as well, and while the story isn't as epic, they're easier to get done.
Don't get me wrong - I run them because I like them! I just wish they were a little shorter.
So as I've said in other threads - my ideal would be something between the two. Closer to the Anthologies, but with only four to eight adventures, with some kind of potential story connections, but with reasonable endings to each. So they could be more in-depth than, for example, the Candlekeep ones, but much shorter than the full campaign books.