I was born on an 'almost cusp' as I like to say, less than an hour after the actual cusp. For those who don't know, the cusp is the point right between two astrological signs.
So, I'm a Cancer/Leo, leaning more towards the Leo side.
The overall descriptions of both signs fit me quite well, and the detailed horoscope a friend drew up for me shortly after I was born has so far proven to be astoundingly correct.
So, as a whole, I 'believe' in astrology - if it's done carefully. I've noticed that most of the people who write horoscopes for the media are just playing along, really.