Do opposing moon signs actually balance out or just clash?

I keep meeting people whose moon sign is opposite mine, and it feels magnetic at first but then we hit the same wall every time. Is that just how it goes, or can it work if both people are self-aware?