I really do feel that Moffat has severe inabilities when it comes to writing plausible, exciting and appealing female characters for scifi

I have to disagree. I thought the Moffat version of Madame de Pompadour was one of the most remarkable TV creations I'd seen in a long time. (My reaction to her is certainly very personal, but it's been enough to keep her in my head for the past two years. I've been reading about 18th century France because of it.) And I found both Nancy and Sally quite memorable.