I like having a default setting when the lore is distant and unobtrusive, like the way Forgotten Realms is used in Lost Mines of Phandelver or a Tales from the Yawning Portal entry; something I don't have to grapple with to run the module, but a vast pool of inspiration when a player wants more background on something, or the party decides to visit a place on the map I haven't prepared. And I think the disposable genericness and extensively developed lore of the Forgotten Realms and the Sword Coast in particular make it perfect for this.
But I don't like the use of the setting in the big 5e campaign books which are often pretty hyper-plugged in to Forgotten Realms lore, feeling the need to namecheck this, that, and the other thing that probably matters to someone who read some novel but that isn't important to anyone I play with. You basically have to continually check the Forgotten Realms Wiki to fully wrap your head around what they are presenting, and frankly in the campaign books I've read I'm not convinced the entire writing staff working on the campaign could keep the lore, and whatever changes the book was making to it, straight.
So my answer is yes, I want to keep the Forgotten Realms as the default setting. It gives people exactly what they expect out of D&D, accommodates all player options, and has an endless bounty of lore that I can take or leave for my version of a campaign. But I think, as it is used in 5e-era full official campaign books, it has been a detriment rather than a boon.