I've been on the pill for a little over 2 years now.
Beofre getting in the pill, I had a fairly high sex drive but after getting on the pill, it dwindled pretty much. There will be times throughout a month that I want sex ALL the time and then there are other times where I don't want it at all.
I've never really had an orgasm from sex so I can't answer that question there. Like I said though, the pill did make my sex drive drop a bit but I still enjoy it on a regular basis pretty much.