Welcome to the forum.
Are you ‘weird and geeky’? No I don’t think so, but you certainly posed a question that is a tougher one to answer.
I think you have partially answered your own question – “It is perhaps a mood best described as a desire to BE in the mood. ”
That alone almost describes the problem in trying to answer your question. The apple you are holding suddenly and powerfully reminds you of your girlfriends breast, but to anyone else it is an apple you are holding.
You can be walking down the street and two little doggies are going at it on the front lawn. You look at them and are fascinated by the energy and enthusiasm that they are putting into it, but the other little old dears walking down the street want to whack them with their canes. Your perception is entirely different than theirs, but it is the same act.
(I’m not trying to be facetious, but extending the idea of ‘a desire to BE in the mood’.)
Here is a link to another thread that discusses a little bit about ‘porn and mood’ that you might find interesting.
Is there a genre of porn for what you are looking for, or trying to describe? I don’t think so. In fact one of the dangers, or pitfalls, is that you may watch a particular porn title, see a scene or part of a scene, and it ‘hits’ you that the one particular scene is just about the hottest thing that you have ever seen in your life. But the second time you put the disc in the player and watch it, you’re not in the same mood and the scene is still very good but doesn’t quite hit you as the ‘hottest thing’ that you have ever seen. Why? Because your mood is different.
Hope this answers your question a little bit.
DenverDon

