A decent overview/review by someone else can be found in the PDF version here :
Anyway, I decided to run this in my custom campaign as a starter, breaking it up into 3 parts, (each chapter being a part). So far I've run the party through Chapter's 1 and 2. Let me say, there is a lot of content in Chapter 1. I ran it in 1 session, cutting out a lot, since I wanted it down to 3-4 hours. (aiming for one session per chapter). First chapter was definitely interesting, and the city has a lot of buildings for players to go to, so prepare accordingly. I had a player ask numerous Dwarves about the large statues out front and simply wasn't prepared since I wanted to run the session as a "brawler".
In any case, it is going well. Chapter 2 offers no map, so instead of using theatre of the mind, I found an underground tunnel map to use and turned it into a scout & cartographer mission to try to find the safest way to the Temple for Chapter 3.
I am planning on running Chapter 3 this Friday and I can't wait!
It definitely has a good amount of content for the price, and as a DM I am hooked, and while debating getting the next piece, there is no FG module for it, and I definitely can't justify the price for a PDF (when a FG MOD would) when after running the first part can just brainstorm how this second part would play out specifically in my homebrew setting anyway.
I so far would rate this adventure 4 to 4.5 out of 5. I think it is pretty good and adaptable, but due to the details takes a thorough reading to understand how you'd want to implement it, especially in a homebrew world/setting. It could possibly use a few more NPC names /details for Stoneholme itself (Chapter 1), especially at this price, but definitely has a good story and seems to have good flexibility as well.