Sex ambivalent ace here, it has been pretty jarring each time a companion hit on my character. It does ask you if you are ok with sexual content and nudity when you first start. I said yes to both because it doesn't usually bother me in most media but maybe being a roleplaying game I feel more connected to the character.

The romance parts feel kinda shoehorned, people will want to hump you pretty much out of the blue. That’s why it feels “horny”. But that’s just a small part of the game, more of a pet peeve. If the horny scenes bother you, those 4-5 times just skip the cutscene.

you'll be missing out on a lot of what people are talking about, but you can absolutely play through the main scenario without having any of the conversations with companions. you get the option to hire retainers instead pretty early.

the more recommended option is to engage with the companions and their stories, but be aware that some choices will lead to a romance option. some companions will just be friendly, others are a bit more in your face with the romance option.

I'm not into romancing games either, but there is so much else to dig into with this game. and the horniness at release was a "bug" presumably getting addressed so it's even less in your face. basically - go ahead and give the game a try, if it's otherwise your kinda thing.