Horoscopes are just entertainment. Don't take them so seriously. If you get along, you get along; life's complicated enough without adding this silly constraint to it!
In my personal case (i'm a pisces girl) when i dated an aquarius boy it lasted for a few months, but then we both realized that romantically we were on different pages, but we were really great friends. So after we broke up we just stayed best friends, because we can really count on each other but we wanted different things (connections etc) romantically. I think I liked spending more time together and i like being more lovey dovey, and he just likes being best friendsy. which is cool, but not for me in a relationship, i want more i guess :P so yeah we're just best friends now. its been over 10 years and we're still best friends and dating didn't make anything awkward =] i still love him, and i'm pretty sure there's room somewhere in his heart for me :)
Like every relationship, the zodiac signs don't really matter as much as the work that goes into it does. So its a good combination if you want it and you work for it. The perfect sign for you doesn't mean its going to magically work out and everything will be perfect. I think it just means you guys will sort of "fit" together quicker or more seamlessly than with a sign you clash with, but in the end, none of this is really proven, its what we believe. and in the end, its the work we put it that determines the benefits we reap