The reality is good sex, or better sex performance to impress, is typically during the beginning of relationships. That is when women want to do anything to get the stupid guys to sign on the doted line!
You left out a category, namely the wife who does her husband even if she doesn't feel like it - and makes it memorable - because she wants to please him.