I only had one internal prior to my water breaking with DS, and, I mean, it wasn't my favorite pregnancy experience. It's not comfortable, but it's not unbearable. It wasn't painful and I didn't have any spotting/bleeding afterward, like I've heard some people do.
It feels better than a pap to me. At least there's no scraping. ::shudders:: I hate that feeling.