I don't think this is an embarassing question as sex is a wonderful and natural thing.
I must say, however, that the thought of a better sex life never crossed my mind as being cf has never been a choice for me. I was born cf -- was given a doll for my 1st b-day and started to cry and said something like: "Want no baby." I feel very uncomfortable with babies and toddlers in particular -- they make me nervous, yet, most important reason is that I don't think they are cute at all. I have been fascinated with career men and women since I was a little kid. Not that I was raised with the idea that I should be a career woman -- it was just a natural feeling and I have always felt that being a succesful career woman is the reason I was born into this world. Like I said, being cf has never been a choice -- I took it for granted as I take it for granted that I am female, a political scientist, black, animal lover, dark red-haired, short etc etc. I love everything that's me. I have mentioned it before on this board: I am a proud member of the World Childfree Association, which is an organization that is NOT against people with kids, but against being forced to make certain choices that can harm both the parent and the kid.
As for your question, Happy CF Guy, I don't think I can give a proper answer to it because I don't know. And my bf doesn't either. I don't know what it is like to want a child and he doesn't either so we also take our sex life for granted the way it is and we have never thought of what it would be like with kids -- not that I am able to reproduce; I was snipped last year on Dec 24 and had a wonderful xmas day -- no pain at all and feeling extremely happy.