The mics I have most regretted buying were the Oktava 219, and AKG C1000 and C3000. But the 219 was by far the worst. If someone held a gun to my head I could probably find a use for the AKG's, but with the Oktava I'd just have to shrug and say: "Do what you gotta do."
I bought a BLUE Mouse that I thought was pretty awful, but turned out it was just broken. Sounded a whole lot better after I sent it back to Skipper.
But mics are like a lot of things - one person's favorite is another's dog. A lot of folks swear by the AT4033, and while it's not awful, I just don't see the excitement. A lot of other people hate the TLM103 and TLM193, but I think they are very useful in the right context.
So take all these opinions with a grain of salt.