Yes, I've known many. But as in any union you have to work at it, it doesn't just happen naturally.
Many opposites are attracted to one another because of the differences in their personalities. They draw on each others strengths, and generally override the weaknesses.
If two people are truly committed to each other, they learn from each others differences and enjoy the challenges. If one or the other is obstinate and unyielding it can pose problems. Depending on the nature of the differences, it can make life much more interesting, or it can make it a total hell. It has everything to do with the individuals involved, and whether or not they are open to new adventures and new experiences.
If two people with opposite likes and dislikes, who are both "set" in their ways should get together, they will undoubtly not stay together long. You have to be a giving person, an understanding person, and a tolerant person to make any relationship work.