To me, the adventure path is only bad when there are no chances for the characters to grow. If a character can go from 1st to 15th level in less than a year then there is a disconnect for me.
.
Before running any plot-based adventure, it's important to get buy-in from the players that they will endeavor to stick to the plot and will come up with solid justification as to why their characters care to see it to the end. What you don't want to do is tell them it's a sandbox game and all roads lead to the storyline. That's railroading. But if you're upfront with the players and get their buy-in, then concerns about railroading go away because they have agreed to stick to the plot. If that's not your bag, don't run or play in plot-driven adventures.
I have no idea how good these adventures are. As it looks now, I will just have to buy it and check them out myself.Quests of Doom (volume 1)
Bugs & Blobs
The Noble Rot by J Collura - 5th-8th level
Hidden Oasis - Temple of Rot by Matt Finch and Bill Webb - 7th-9th level
Demons & Devils
Ra's Evil Grin - by Bill Webb and Clark Peterson - 11th level
Sorcerer's Citadel by Bill Webb and Clark Peterson - 9th level
Giants & Dragons
The Dead from Above by Michael Curtis - 6th-8th level
Emeralds of Highfang by Ed Greenwood - no levels given except "high level"
Lycanthropes & Elementals
Bad Moon Rising by Steve Winter - 4th-6th level
Death in Dyrgalas by Skip Williams - 6th-8th level
Men & Monstrosities
Deep in the Vale by James M. Ward - 1st level
Irtep's Dish by Casey W. Christofferson (with additional material by Scott Greene) - 6th-8th level
Vampires & Liches
The Pyramid of Amra by Casey W. Christofferson and Bill Webb - 12th level
Sewers of the Underguild by Casey W. Christofferson and Bill Webb - 11th-15th level
But it's not like you have to play adventure paths. You have dozens of 3rd party adventures out there that last from one hour to a few sessions. You can also adapt the old TSR magazine adventures that you can find for free on the Internet. If you want 5e content, you can subscribe to EN5IDER and get a monthly adventure. Many of these adventures are much better than the ones published by WoTC.

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.