Who told you that they use thicker needles for old school tattoos? I have all Japanese style tattoos and my artist uses the old style machine. They ALL vibrate. Sounds like you've been listening to a bunch of bullshit.
Tattoos hurt. If you're afraid of pain, don't get one. Also, tattoos don't make you a tough guy. I know tough guys with no tattoos and I know pussies with tattoos. You're either a tough guy or you're not.
It doesn't sound like you're cut out for tattoos, but if you really want one, find a GOOD shop and go talk to someone. Be honest about your concerns and see what they say.