I have an offensive super gourgeist on my pokebank OU team and he actually works very well as a hit-and-run bulky physical attacker/revenge killer/spin blocker with my set
Gourgeist-Super @ Life Orb
Ability: Frisk
EVs: 252 Att, HP/4 Def
Adamant Nature
Trick-or-Treat
Shadow Sneak
Seed Bomb
WoW
Basically, use this set to force a switch and they'll most likely go into their sweeper that would want to set up on a gourgeist. Use Trick-or-Treat on the switch turning their sweeper into a ghost type then follow up with a STAB, priority, super effective shadow sneak that'll one shot, if not severely damage their sweeper. A logical player will try and set up with their sweeper the very turn you just rekt him with shadow sneak. If you know he'll switch into his sweeper and you know that your main damage combo will only 3 shot their sweeper, you can also cripple their sweeper with WoW on the switch. He'll be forced to switch and if he doesn't he'll take another priority shadow sneak and die. Gourgeist-Super can also revenge kill very well with shadow sneak and ofc. spin block with his ghost typing. However, Gourgeist won't be able to OHKO the sweeper, ever, with his shadow sneak so he needs a lot of supporting and setting up outside of his Trick-or-Treat-Shadow Sneak combo e.g. on my team with gourgeist I have a prankster-spikes-sash klefki to garuntee 2 layers of spikes and an avalugg with roar to force a lot of switches and harass them with spikes. With at least 2 layers of spikes(3 being much more likely) Gourgeist's combo will be able to most likely one shot their sweeper, though. He's certainly difficult to play in the higher tiers but he still can work very well. I'll try and get a good replay showing off his potential for you guys to see.