Given that they've been a player-facing race since Unearthed Arcana in the mid-80s I'm another one who doesn't see the big deal.If a player wants to play a drow that's fine by me. Its an opportunity to use the Drow as a cool plot hook.
My 4e campaign featured a drow sorcerer PC - as per the player-authored backstory he was a member of the Order of the Bat, a group of Corellon-worshipping drow who seek to undo the sundering of the elves and bring their brethren back to the surface world. He would sing lays (maybe laments?) of walking under the starlight; sometime in mid-heroic, and again in epic, the PC multi-classed as a bard. (On the way through he was, via retraining, also multiclassed as a cutthroat - a sort of assassin prestige class - and as a drow-fu-using monk.)
Around 29th level he achieved his goal - Lolth was killed and the Underdark was destroyed, but many drow were led back to the surface world.
Back in the 90s, in our Rolemaster GH game, at one stage we had some orc PCs, and a long-running ogre PC who came from the Rakers/Bone March area.