With the UK premiere of two dramas exploring sexuality, Sarah Hemming examines the point of putting such private moments on to a public stage