As someone who has only played Indigo Prophecy and not the uncensored version I can tell you that it didn't affect my love for the game
I don't think sex is that nessesary but it is kind of odd that censors make it out to be worse than violence (when sex is natural and killing a man is wrong).