I have to admit I have gotten turned on by my own fic. In one case it was a fic where I didn't even like the pairing much but just wrote it to see if I could.

It doesn't usually happen, but it happens sometimes. But usually not until I re-read the scene, as opposed to when I'm actually writing it.