The thing with tattoos is that although needles r used, u dont really see them, & so u dont really fear them. My bf got a tattoo, & he is terrified of needles. Proof that a wuss can get a tattoo lol.
Secondly the pain varies from place to place. Nearer the bone(bits with less flesh) hurt a lot more. But in fleshier places a tattoo doesnt hurt too bad! For an example a tattoo feels like a cat scratch, a scrape(like when u scrape u arm on a wall or something) or even a bee sting. It is like a hot stingy pain- but it is deffinately not unbearable, & u really do get used to it after awhile.
After wards u need to keep the tattoo clean. The aftercare is very simple. You just need to wash the tattoo twice a day with a very mild soap & some warm water. Then u need to apply a cream to it. My tattooist recommended bepanthan (which is a nappy rash cream for babies) & it worked really well!
Like I mentioned earlier, my bf hates needles, & he is not really the type of person to go for tattoos, yet he went & got one. Me? I love needles, I've got a tatt (planning more) & thirteen piercings. But u dont have to like needles to be able to cope, honestly!
Anyway, I hope that helped u a bit. If u want any more info, just ask & I will be happy to help u as best as I can. Also, if u do decide to go for a tattoo, ur tattooist will be able to tell u anything & eveything u ever wanted to know about tattoos- icluding procedure, aftercare, pain scales, time, cost, etc etc.
Good luck!