A Premium Adventure, If You're Willing To Do The Work:
Scourge of the Sword Coast has a lot to love, and my players had a great time with it - but in the modern era, it'll take some work to get the best out of it.
Let's start with the good. The first thing you'll notice are the production values. Scourge of the Sword Coast is packed with top-tier original artwork. Every NPC has a full-colour portrait, and every location has a map so gorgeous you'll want to hang it on your wall. (Cartographer Mike Schley doesn't get enough love for his early 5E work.)
Secondly, this is simply a great introduction to low-level D&D. It's got a small-town base - Daggerford - and a range of outlying dungeon locations that players can explore in an order of their choosing. The dungeons themselves support a range of play-styles, including combat, stealth, diplomacy and puzzle solving, but never force players into a mode of play they don't enjoy. The NPCs are memorable, and well-defined, with clear goals, priorities and quirks (the portraits also help). It's the wonderful kind of adventure that lets players do deep-dive roleplaying when they're in the mood, and skip straight to bashing things when they're not. It's an adventure that's worth taking the effort to run.
Next, let's talk about the difficulties. This is a "D&D Next" product, using 5E playtest rules rather than the now-official version of the game. Conversion is by and large extremely easy, and most of the featured monsters have a similar 5E equivalent in the Monster Manual, but some of the featured villains will take some work to rebuild for a 5E party, and a few of the monsters got buffed enough in the Monster Manual that you'll need to dial them back down to be appropriate for low-level parties.
In addition, this is a story that benefits strongly from your players having familiarity with "Ghosts of Dragonspear Castle", and it has plot threads that continue into "Dead In Thay" - but any character who survived Dragonspear is too high-level to take part in Scourge, and any character who survives Scourge is too low to do Thay. It'll take some creative DM work to string these three products together into a cohesive experience. (I did it by having players re-roll after Dragonspear, and then adding an additional adventure between Scourge and Thay to ease them through the level disparity.)
Lastly, the (very few) bad points. (1) There are some puzzle sections in a dwarven mine that are tedious and very poorly designed. We skipped them entirely and I recommend that you do too. (2) Of the few featured women NPCs, more than one of them turns out to fall into the trope of "evil jealous/promiscuous manipulator", which my players quite rightly called out as tired, lazy and problematic. (3) A fair bit of the plot hinges around the quite complicated family politics of the Floshin family, and the module either needed more resources for DMs on this bit of Realmslore, or to rely on it less strongly for the story. Even as a Realms nerd, this was confusing for me, and my players needed regular reminders of who was related to who, and why.
In any case, I strongly recommend this adventure for anyone willing to do the work to adapt it.
Notes on the print-on-demand edition: The POD version that I received was very good for a POD, although it'll never be mistaken for a regular commercial print. It's a thin perfect-bound volume, with the name printed on the spine. The cover is made of thin card. The entire book is in full-colour, and the printing quality is generally good. The full-colour art looks impressive, but there's a grainy look to the remainder of the book (which admittedly is also present in the PDF version), and a lack of crispness to the text. If you're a regular POD customer you'll know that in some products there are issues with oversized maps being chopped up in ways that make them useless, so you'll be glad to know that this is NOT an issue here - everything is designed for A4 printing and looks fine in book format. This is one of the better DM'S Guild POD products, and will make a good addition to your bookshelf.