You'll probably enjoy it, but you won't know until you try. No reason to worry. You could be setting yourself up for failure if you build it up too much. Have realistic expectations. Enjoy it for what it is and if you decide it's not for you any longer that's fine too. At least you'll have the satisfaction of knowing instead of guessing and being bold instead of chickening out. Last thing, don't be too quick to make a decision. Some dogs, like people, just aren't good at sex. You might have to try several k9 partners to find a compatible one. After all, I suspect you didn't give up sex with a human just because you've had a poor human partner.
