Nothing like it. First, it's SO FREAKING noisy on the Switch. It reminds me of someone leaving their phone on a wooden desk, and it getting a text message, except think of it like that cellphone getting SPAMMED with text messages. It's just a stupendously annoying sound, and totally triggers a stress response from me. It's hard to really get over that, first of all.
I don't think the actual rumble is that impressive. It just feels... messy, for lack of a better word. Bear in mind I've only played Puyo/Tetris and Fast Racing RMX really, and the noise is just so freaking annoying. You'll hear it over the TV, over the Switch speakers etc. Much like many things with Nintendo recently, I've no idea how this passed QC.
In terms of comparison to the DS4 or XBOne rumble, their rumbles are of course different, but they're lower in pitch, and much smoother, more... subtle. Switch HD Rumble is in your face, high-pitched, lacking in all subtlety, and I HATE IT.
And yes, that is how I really feel. I'm so glad you can disable it in the Settings of the console.