How bad is it to think of an ex even of it fizzled out?

So had great sex with an ex years ago. Things went south sexually along with everything else. Still though there was a time of extreme hotness that’d I’ve never found even though I’ve moved on. Normal?