I've been running D&D for 30 years now, and while I acquired many of the 2E Forgotten Realms boxed sets and accessories in the 90s, for many years my only connection the setting was the novels. And there were a lot, and they ranged all over the place, which felt for me like established ground. I didn't want to use the setting for my game because it felt like all of these named, story-based NPCs were already there. And for a period of time, it felt like everything was tied to Drizzt Do'Urden to a nauseating degree.
The 3E Forgotten Realms Campaign Setting was (heck, still is) an absolute treasure in terms of usable content for building campaigns set almost anywhere in Faerun. Sure, there were stats for some key hero NPCs, but they didn't bother me. The setting had so much rich lore and the maps were so gorgeous and evocative. I ended up picking up many of the 3E supplements, but for the most part they were fun reading material due to life circumstances. I did try to get a City of the Spider Queen campaign off the ground but it died in session 0 due to lack of player interest (interest in gaming in general at the time, not specifically FR). I still have the metal drider miniatures from Reaper I bought for that campaign painted up and ready to use! Some day ...
Fast forward a bit and I started running games for Adventurers League at GenCon 2014 with the launch of the 5E rules, and the adventures were fun, plain and simple. Sure, as DMs we had to wear horribly itchy cult robes for the con, but I had so much fun running players through the one hour mini adventures. Phlan was a fun setting, the factions were iconic, and the adventures did a great job of empowering the DM to make it their game at their table. My home game turned towards FR as well, partly because the content being released was set there - I ran Legacy of the Crystal Shard for my home group, which was a total blast! AL was my main game for many years between GenCon, GaryCon, Gamehole Con, and Origins, and I ran games at my FLGS for a few years too. Undermountain and Myth Drannor are my two favorite places in the whole Realms, but Vaasa, Cormyr, the Moonsea, Sword Coast, and more are interesting, evocative places to set adventures.
I've found myself enjoying Forgotten Realms thanks to its rich details and high fantasy spirit, along with its villains and powerful factions. I love the sense of adventure that permeates each corner of Faerun. I wish I had players that were invested in the setting since it's readily accessible, but I've learned my home group just doesn't lock into settings. Which is fine, totally fine, I'm fine.