I'll try to be as candid with my answer as possible, because I do have two of such mods and I am curious of other people's answers as well. One, was because as a new modder I didn't really understand a lot. It's sort of an IT joke with my friends to use adult content to test functionality of certain things (Example: Testing a new internet connection by visiting a random porn site etc). Its sort of an inside joke. So i used one to test FNIS. The second had immersive purposes, being a prostitution mod (the oldest profession, even in Skyrim lol).
For the record, I generally consider myself to be asexual, (and my answers aren't likely accurate to what you're asking of others). So I get no real "thrill" from these mods. I more so find myself impressed with the complexity of their creation, especially script heavy ones, and how they are added into the game, there is a certain sense of art to it and other adult contents aside from game modding. Also comedy when I forget one of the necessary requirements and characters bend in weird ways or T-pose on top of one another motionless.
But I do fail to understand how anyone can find serious sexual interest in these mods, or any animated adult content that does not closely mimic real life. I don't understand how anime porn can make people aroused because, at least to me, it just looks like a cartoon. Maybe well made, but so far from life I can't understand how it evokes such a response. I'm not judging these people by the way, I just don't understand the biology/psychology behind it. If something real is available (and often free) why settle for a cartoon or a game mod? And how does something so unreal illicit the proper response within the body?
For the most part I don't use the mods, and likely won't install them again as they were mostly just testing grounds. Actually I'm mid reinstall due to serious game breaking problems. I probably won't install them again. Saving my scripting mods for things like Sacrosanct and Thunderchild now.
Edit: As for the lore question. I suppose it all comes down to how you define lore vs role playing. In my youth I rarely cared for game lore and preferred my "personal lore". But that was when I was very young. I do have more interest in established lore now. But I mostly spend my Skyrim time seeing how far I can push things before they break these days. The current standing is 5 full re-installs.
Edited by WakahisaSensei, 17 September 2018 - 01:27 AM.