As has been pointed out, cold depends on what you're wearing...
Without a wetsuit:
90F is warm. Sometimes too warm, especially if what you really want is a nice refreshing swim.
80F is generally comfortable.
70F is chilly, but if the sun's out, and you've been working hard (say after a day of backpacking) it's about perfect.
60F is cold. Especially if you were expecting something several degrees warmer (Gah! They've drawn-down the reservoir to below the thermocline!!!)
50F is numbingly cold.
40F is "get in, get wet, get out" in under a minute.
On the other hand, with a nice 2x7mm wetsuit:
60F is quite comfortable. Heck if the weather's cold and rainy (or really hot and humid) it may be more pleasant than whatevers on the surface.
50F is "please pass me my hood and gloves", but generally pretty good, at least for an hour or so.
I don't think I've been colder than the high-40's... you start feeling exposed flesh get numb, but as long as the suit doesn't leak, your core stays reasonably comfortable. Mind you, that's only for a short duration.
With a drysuit, I can only theorize, but since a good snow-suit will keep you warm in air-temps down below -40F (plus windchill on top of that), well, I think you'd have a hard time getting water cold enough to be an issue. Double-layers of long-undies though
Jamie