Don't worry about the pain. Pain should not be part of your decision to get your first tattoo IMHO.
Depending on where you get it, the pain will be worse, or minor. I find my arms are EASY and hurt very little. The back of my neck was quite a bit more painful, while the back of my shoulders was in the middle of the two.
If you WANT a tattoo, think of the pain as part of the process, part of the reason you will be proud to have it when it's done. Getting anything bigger than a couple inches done anywhere on your body is a personal test though for sure if it lasts a few hours and you can really learn how much you can take. It's NOTHING like getting a shot or normal needle. More like electricity, or a sun burn.