I’ve experimented quite a bit with piezos on percussion. The only thing I’ve found remotely decent was the Zeppelin Design Labs Cortado MK II. I’ve used it with a LP Laptop Conga (attached with blue tack). If you slide your hands at all you get a lot of whooshy white noise, and you can get noise from jostling the cable, but otherwise it sounds pretty much like a normal microphone minus any room ambiance. Apparently they also use them under basketball courts for TV broadcasts.
It’s a bit on the expensive side but they have a much cheaper DIY kit version if you are at all handy with electronics. It does require phantom power.
I think I misspoke slightly here. I have the MK III and it appears to be the MK II that is available as a kit. Not sure what the differences are.