While the syphilis theory is plausible, I believe the congenital brain disease inherited from his father is the more widely accepted theory nowadays.
As for the horse story, apparently it comes from a tabloid paper that was never exactly known for their reputability. The "gossipy" undertones become very clear when you read the article for yourself.