The cost depends on where you get it pierced and what you use as the piercing.
It cost my mom 65 in USD (about €54) for the lobe piercing.
It hardly hurt, but it starts to sting a little bit after you get it pierced.
You can't 'feel' the needle as it's inside your ear, but the best way to describe it is someone pinching your ear with their canine teeth.
Of course this is just my experience with my lobes, I'm not sure about other piercings.