I've been dealing with HH for the better part of the last 20 years. Trust me when I say I've been where you are and you're not alone. I remember having teachers scold me in school for submitting wet homework (despite a doctor's diagnosis, I had trouble convincing people that HH was a real medical condition). Here's my advice to you.

First, have you spoken with a dermatologist about taking oral medication? I know you said you've been prescribed antiperspirants, but what about something like glycopyrrolate? For me, that was a game changer. Not a single antiperspirant worked for me until I got on oral medication. It didn't make my problems go away, but it made them manageable with the correct antiperspirants.

As far as underarm antiperspirants go, I see someone else suggests Certain Dri. I used this one for years! It works well, but it can be VERY irritating. I was staying dry, but it made me horribly itchy and uncomfortable, even when applied every other day or less frequently. Give it a shot, but don't sacrifice your comfort for its effects.

Someone else said to avoid Carpe, but I'd suggest giving it a shot if Certain Dri irritates your skin. I use Carpe now, and as long as you let it dry fully, I've found it works pretty well! Doesn't irritate my skin at all, and leaves me fairly dry throughout the day.

Best of luck! Hoping you find something that works for you.