I used DSP for a while, it is brilliant, especially if you like t ride without gloves. But it also costs a fortune and didn’t wear any better than cheap tape.
As for anything else, I’ve not noticed much more than you can tell at first glance. Foam tapes are good all round, fizik tapes look cool with the contrasting stitches, cinelli and Deda tapes are Italian and therefore roadie-cool, leather look tapes are nice on the right bikes. All much of a muchness in use though, sometimes I pick something nice, other times I fit £2.99 tape and replace it when I fancy a change of colour or it gets grubby. For comfort just add an extra strip where needed (along the tops of the bars and bends and in the drops).