We've been to both Cocoa and Clearwater and I would highly suggest going over to the Gulf side.
Cocoa Beach, the water was VERY rough, we couldn't get in it without being knocked over. The sand is dark and coarse. The water isn't very pretty, either.
At Clearwater, or really any Gulf...