Feeling upset

So lately I've been having issues with not being able to get wet during sex. Doesn't matter wether I am 100% in the mood or not and its really getting to me. It's rare when I do get wet and when I do it's amazing, but like I said it's rare. I know a lot of your are going to suggest lube (oil and water based) but I've tried it and honestly I'd rather get down to the bottom of this issue. I hate having to pause and get more. It's been on going for about 2 years and it's ruining my sex life, I don't enjoy it and it's embarrassing. Last time I got super wet I actually had liquor in my system which is weird cause that'll usually make it worst, the next time I had liquor in my system too and I was as dry as a damn desert, been active two more times after that and no luck. Has anyone dealt with this and figured out what's causing it? I got my hormones and all checked and "everything is normal"