In terms of high, the various types of concentrates you would use in a dab rig are relatively the same. About the same variation as weed.

But the consistency can change how well it smokes/vapes. I like shatter for dabs because it's easy to break off a chunk and drop it in/on the hot plate. I like crumble with a nectar collector because it is easy to make "lines" like I'm snorting coke, but is melty and sticky enough that it doesn't get sucked up like a powder or slurped up like something more liquidy like live resin.

Distillate vs live resin or shatter or crumble and what not isn't the same high. It's more uniform across the spectrum of breeds used and the high is short lived and feels only slightly the same as what you'd expect from weed. It's usually what's in a cart. If you like carts, you gotta look specifically for live resin or rosin because distillate sucks.