D&D 5E (2024) Is WOTC done publishing campaigns?

[Marandahir]

Lightly railroaded in a sandbox works. HotDQ was very railroaded.

Once around the Realm type adventures don't tend to be very good.

One thing I've found works really well for Once 'Round the Realms adventures like HotDQ is the ability to plug and play other modules and sandboxes into the game to layer multiple B plots over the adventure and make it feel significantly less railroaded.

As HotQ wanders long road and river journeys from Greenfields, Elturel, Baldur's Gate, Dragonspear Castle, Daggerford, Waterdeep, and the Mere of Dead Men (itself very close Phandalin & Phandelver, as well as the setting of the Essentials Kit sandbox).

5E has a bunch of core WotC-published adventures that line up with this journey, and the DM's Guild (and AL and Guild Adepts program) have a lot of smaller adventures that plug into the various adventure seasons.

 

[AnotherGuy]

Is Tyranny as bad as some folks say? That's a good price for a big fat module.

It is my favoutite 5e AP and is the cornerstone of my table's campaign (but I have incorporated many of other 5e APs and modules within the same time frame).
HOWEVER it requires work, but if it's your passion to tinker and flesh out APs then it's all joy. The internet has a treasure trove of helpful and inspirational material and ideas.

If you don't have the time or inclination then ToD is not for you.