Juliefrazz, whereabouts in the West Mids are you? I can recommend Tribal Images in Stoke (Hanley) -http://www.tribalimages.co.uk/ .
I have a butterfly design that starts on my inner forearm and twists all the way up the back of my arm, finishing on the shoulder, and I love it so much - people are always commenting on it and asking where I had it done. The artist also reworked some lyrics I'd had done elsewhere but wasn't happy with, and they look way better now.
Also check out www.deviantart.com for inspiration - there are lots of fantastic ones on there (just do a search for the sort of things you have in mind, or look in the Body Art section under Traditional Art).
The perfect design will just come to you one day. I knew I wanted those lyrics, then spotted a gorgeous butterfly back tattoo on the internet, and the design just grew from there. I've since had microdermal piercings added to the upper arm and can definitely recommend those too!
As for the pain, it's really not that bad at all - in fact, I rather enjoy being tattooed. And pierced for that matter...
This is one of my favourite subjects, can you tell? 