I've been trying Golisopod a little on Showdown and I feel the meta is just too unkind to it right now to be very useful. I've been using him as a hit and run to pick off weakened opponents with his priority, but a lot of the current threats just resist his stabs or easily play around him. Aegislash, Garchomp, Mantine, Toxapex, Tapu Fini, Tapu Bulu, Heatran
You should definitely have teammates to get passed unfavorable match ups, but point is in my experience Golisopod hasn't been able to revenge too many things since often times teams right now are made up largely of things that handle his stab priority pretty well, and the things that don't are taken care of fairly easily without him.
I ran Assault Vest at first and then switched over to life orb which I ended up preferring on a hit and run mon. Oddly enough though, of all things holding him back I felt his ability was NOT one of them. With a bulkier set he does his job of chipping at the opponent and his ability let's him get out immediately to something that finishes the job if he couldn't, without wasting a turn. And in tougher situations where you need a safe switch, instead of sacking a teammate, if Golisopod is healthy to survive the hit with less than 50% on the switch, his ability will let you switch in that Pokemon you wanted safely.
I definitely think he has his niche, but he's not becoming the go to revenge killer any time soon, and his bulky pivoting is ok. Maybe after a few things end up band he might have more utility. I love his design and theme so I'll definitely be trying him again later on.