When I have "prominent haptics" turned on (which is pretty much all the time), I get a buzz-tap for a text and a single tap for, say, an appointment reminder.
I can't remember if other notifications are different. And, I haven't seen a more granular way to set different taps.