Best non-WotSC campaign modules?

Baby DM here. Someone on DMAcademy recently posted about how unworkable WotSC modules are. Well, I had no idea. I’ve been operating under the impression that I can run my Forgotten Realms-based homebrew and weave in the threads of an official campaign module as the story unfolded. I was banking on the wisdom and excitement of a WotSC module because, like all so many of us, my job keeps me busy, but also because as a new DM, I figured I could learn from the official modules.

So help me out. Can I still learn a lot from these modules? Are they a waste? And also, what are your recommendations for non-WotSC modules a baby DM should run to get good?