I re-read my latest chapters several times when I'm done, but that's mainly to find the 20th missed typo and also think about where the story is going now.
I will say that on occasion I'll open up something from months ago. Usually if someone likes an old chapter I'll think, hey it's been a while, so I'll click on it. And yeah, things I thought were sexy enough to write about back then are still sexy to me now, but then I usually start reading again for the story.
And yeah, for sure there are times when I sort of forgot a scene that makes me go "damn that was actually pretty hot". When I first started I wrote dozens of chapters and tens of thousands of words my first two weeks and going back to that story is trippy. Those are the fantasies I had in my head for years and years without an outlet for them so the action is, to me, very hot. Now when I write I think I enjoy the characters and actual storytelling more (glances at current story that got to 29K words before anyone even kissed).