Private
Yes, nude photos with sexual themes sometimes are on show. Not often but that's a possibility in the smaller museums. It looks like the two shows at the ICP are not like that, one is about public verses private self and the other is about US presidents through public and private photos. Not the most exciting at the moment.
The exhibitions at the MET look a bit more interesting. I know I see some I'd be intrigued by, perhaps that'd apply to you and Hank as well.