score:7
The verses in 1 Cor 6 make clear that sexual sins are a special kind of sin:
Flee sexual immorality. Every sin that a man does is outside the body, but he who commits sexual immorality sins against his own body.
The commentary of David Guzik about this:
Paul isnβt saying sexual immorality is worse than any other sin; but he does teach that sexual sin has a unique effect on the body; not only in a physical way, but also in a moral and spiritual ways.
How this should be interpreted is however not exactly clear. I heard mentioning somewhere: if someone falls in sexual sins and his missteps are somehow made public, it is hard to see this person without thinking about those particular sins he committed. But that is just one interpretation.
One consequence is certain. Sexual immorality will hinder the spiritual life because they pollute the temple of the Holy Spirit:
Or do you not know that your body is the temple of the Holy Spirit who is in you, whom you have from God, and you are not your own?
Upvote:1
Please note that I'm answering primarily from a practical perspective here; as per the question:
More specifically focusing on here, not the after life.
I am answering primarily about reality in this world, not Biblically.
First, we must define "sexual sin"; I'm first going to assume we mean fairly "light" things, such as masturbation, consensual sex of unmarried persons, contraception, same-sex sex, sex acts between a couple that can't lead to procreation, etc.
Well, here the expected results are pretty much... minimal. I would be making assumptions in here such as safe-sex to avoid unwanted physical effects such as STDs (if promiscuous), or an undesired pregnancy. You aren't going to be struck blind, get hairy hands, or outright die from masturbation. The most "immoral" cities are not smited (smote?). The most likely outcomes are:
Moving on, we get into areas such as p**nography and adultery (just as example); the first is deeply complex, and frankly I'm not qualified to comment - the are, of both genders, proponents and opponents, people who say it enslaves and people (including women) who say it liberates. Those that say it harms society and objectifies the participants, and those who say the opposite. I'm not going to wade into that, but: access to p**nography (in an Internet age) is at an all-time high, but sexual crime has not increased to match (indeed, is generally reported as falling). I make no analysis of that, due to lack of qualification.
Adultery, these days, is not likely to get you stoned to death in the village square. In the majority of cases this is done as a secret and clandestine thing, which can (when discovered) negatively impact (or destroy) a relationship, and otherwise is likely to (as a side-effect) cause a combination of excitement (adrenalin etc), but other emotions too (guilt, furtiveness, stress). In some more.... "open" relationships, it is not a betrayal of trust, obviously. I'll let people decide on what their own relationship is.
I'm not going to go into sexual crime as sin, as the effects in this world are well known.
Does it make the person feel emotionally oppressed on some level or does it just separate them from God spiritually without any effect here?
For the former; quite the opposite. Recognising one's own sexuality is liberating. It is the denial of sexuality that is oppression. Feeling guilt at masturbation is infantile; feeling shame at recognising (say) same-sex attraction causes harm, both in loss of happiness, and (quite often) harm to others when those feelings don't go away, and lead, quite often, to a "need" to pursue those inner drives, but often in more secretive ways, which is harmful psychologically, and even more harmful if it becomes public knowledge later. We all know of the many "upsets" caused when even some of the most vocal anti-h*m*sexual voices have been exposed in secret h*m*sexual liaisons. This demonstrably points to massive cognitive dissonance, guilt, shame, repression, etc. Not healthy. And equally, there are some very religious and good people who would be classified as sexual sinners because they acknowledge the reality of their feelings.
For the latter (separation from God), I am not well-placed to comment.
Sex, in a lot of animals (especially primates), not just man, is a lot more complex than purely procreation.
tl;dr; no evidence of Biblical style punishment in this world is evident (nobody struck down, no cities destroyed). However, like must things in life, if we lie and cheat (etc) that can harm our relationships.