Personally, I have trouble reading 2nd person perspective because it requires the reader to step into the identity of the protagonist. Usually, however, the protagonist has a very distinct personality that would make such virtual identification impossible. There are many authors who have tried this way as a gimmick (Tom Robbins and Jay McInerney for example) but the only online example I can think of is a short piece by Nathaniel Hawthorn called Haunted Mind.

There are some mystery stories that used 3rd person omniscient whereby the author would give the reader all they needed to know. However, the significance of the clues won't come together until the end of the work when the brilliant detective reveals everything. A good example is James Andersons Affair of the Bloodstained Egg Cosy.

I wasn't familiar with the other two forms of 3rd person in the link. I've just heard of 3rd person limited. By telling a story from only one person's perspective you can suck the reader in and have them forget that truth is relative. The character can have their own agenda and/or bias and it isn't until there is interaction with other characters that we see the flaws. One of the finest examples of this is Chronicle of a Death Foretold by Gabriel Garcia Marquez. It is a murder story told from 4 different perspectives and each time more is revealed.

Sorry that I couldn't give examples from erotica but my r/l bookshelves were easier to rifle through than the archives in the bdsmlibrary.