im confused about sex....

I see posts on here saying they have had amazing sex and all that ( im a virgin btw) but then I see so many posts saying it hurts and you get cramps, and how it hurts so im confused is it a pleasurable experience or a hurtful experience???