Kind of reminds me of some of the other route rodents like Linoone and Bibarel. They have these clear situations where they can be very strong, but it's not very reliable or practical and if pulled off probably still isn't going to take over the game. Linoone gets Belly Drum Extremespeed, Bibarel gets mean if it has a chance to set up.
I honestly think Gumshoos has one of the clearer, more realistic success cases though. It mostly just needs to be sent out at the right time, then you can have a giggle as it hits whatever switches in very hard and does its job.
It's a little bit bulkier than Floatzel so it might be able to take one hit before it goes down. You could probably even run a cheesy set consisting only of Yawn and Last Resort with red card or something like that. Last resort on a Pokemon switching in against this guy will hit like a truck.