The stories of these closeted notables range from bittersweet to tragic, and some are just plain outrageous.