I simply don't buy into the idea that NPCs should become targets or plot hooks outside of what's logical and would have occured in any case. It is as if DMs believe that the moment a character has a close, personal relationship with any NPC, be it in their character history or one developed along the roads of adventure, that NPC is now an immediate and overwhelming target of multiple plots, villains, or simple tragedy.
The annoying part about this, for me, is that if said NPC had never gained the affections of the PC, none of this would have happened. How precisely do the BBEGs have this immediate and all seeing knowledge of who PCs care the most for, anyway? Do they have spies constantly observing the PC ready to strike at anyone who becomes close to them for the merest of instants?
This gets even worse when you consider NPCs that are introduced in the midst of an adventure, who becomes liked or close to a PC. Said NPC suddenly and inexplicably becomes embroiled in numerous plot threads, re occuring appearances, and all manner of other tomfoolery that forces the PCs to take action to help them. This is, to me, just as bad and forced as DMNPCs who solve all the parties problems are.
Is it any wonder with this strange cosmic force irrevokably causing chaos and pain for anyone who gets close to a PC, that so many PCs become the distant loner, the solitary warrior, the vigilant guardian standing by himself against the hordes of evil, the hardass merc who doesn't give a damn, and ad nauseum throughout the stereotypes of people who just don't get close to anybody.
Create an interesting, different character that has close family, good friends, and is out adventuring in part to make the world a better place for those people, or only for a while as he works to win through so he can return to his loved ones, would be a great change of pace. But at the same time, I understand why just about nobody ever does this, because every time they even hint at it, the fates, for no good reason and with no apparent logic, wreak havoc on everything they care about.