You being in a relationship with, or having sex with, your direct manager isn't (just) about discomfort, it's about unprofessionalism.

There are plenty of people to have sex or relationships with. You don't need to look to your direct employees.