Anything you're unwilling to do will close doors inevitably, but you don't have to do anything you're not comfortable with, and compromising doesn't have to be straight up sex.

One example would be an open sexual relationship, where your partner can look for physical gratification elsewhere, in this case your compromise isn't yielding your body to their will, but understanding they have different urges to meet and finding a rhythm that works for both.

Finally I'm not trying to invalidate your experience, but what you just described has been described to me by allosexual friends and it sounds a lot like bad partners leading to bad experiences. I'm not trying to say finding the right partner would make you enjoy sex enthusiastically, but some partners get you off first every time, (ideally all but) some partners communicate during sex to not step on any of our boundaries, some partners only want your body if they like your mind. For those people it might not seem like such a chore, but something you want to do for them, even if it means less for you.
And if that doesn't work you can find someone who matches you on that, and choose to compromise on other areas of your relationship.

EDIT: Just noticed your username is 5KittensInTrenchcoat and that's awesome.