I've known several tsunderes, male and female, and dated one. Reason why that didn't work out had more to do with me not wanting to have sex than anything else, which is understandable even from my viewpoint. I've also befriended*
a lot of jerkass people and bullies, who for some reason show a softer side to me, if that counts as tsundere.
A yandere, not really. Someone who's jealous enough do disallow me to meet with a sexually compatible person would find an exit door very quickly. Some jealousy is fine, but that much? No. It reeks of distrust, and trust is one of the most important parts of a relationship for me. I essentially quit my last job over that.