Firstly, huge sympathies - bad separation anxiety is awful, oth for the dog and for you. My Weimaraner, who I’ve had from a puppy, developed it after my older dog died when they were in kennels together, and then lockdown just reinforced it. With her, the panic started as soon as I went through the door, she’d throw herself at the door and the windows, yelping and howling, and I used to worry that she’d hurt herself. The genuine panic she felt was obvious - racing heart, dilated eyes, panting and even frothing at the mouth. Awful.
I had so many trainers and behaviourists, all of whom agreed that she was a particularly bad case (no shit Sherlock 🙄) but their method of start short and build up wasn’t really useful as she started the instant the door shut. I persevered on my own, trying all sorts of things, and now, at the age of 8, she’s ok for a couple of hours. Mostly 😁
What has worked for us is to tire her out with a good sniffy walk, so she has lots of mental stuff to process. Then I clear the kitchen worksurfaces (damage limitation), and wedge the door shut (she can open handles) before I give her a frozen split marrow bone from the butcher. Frozen means she has to lick it, rather than chew. When I leave the house, she’s better when she sees me go (against everything the trainers said) as then she knows she hasn’t mislaid me somewhere, I imagine.
She also has a dog-walker twice a week, who she absolutely adores, and this has been helpful I think for her to realise she can have fun without me being there. I think the thing is, you need to find what things will suit your dog, and it might not be the conventional methods. I did find the dog enrichment ideas on the internet were really helpful. It’s not a quick fix, unfortunately, so it won’t help you for your hospital appointment this time, but don’t give up. I wish you good luck in finding a solution for your boy.