Very nearby you can grab food and refreshments at Regatta Cafe or catch the NYC Water Taxi and find comfort in the usually well kept restrooms. During the Summer the Hudson River Park Trust sponsors free concerts of varied genres of music.
Sometimes called 'Queer Pier'
Being at the end of Christopher Street does result in attracting gay users but having used Pier 45 on many occasions, my family and I have not found this to be in the least bit disconcerting. In fact, it does not in any way detract from the excellent facilities, views of the Hudson River, shipping, and New Jersey shoreline and overall enjoyment factor. It has to be - given the weather of course - one of NYC's cheapest (free if you don't use the cafe) leisure spots. SSh - don't tell everybody!