@Vincent Berg
1st-Omni, where the story is told in first-person, yet it has a Omniscient 3rd-person narrator
I think the way this works is still with first person narrator, but an older-self narrating from a knowledge of future. Like, say, an old man retelling his school age misdeeds. In such, the near-omni narrator, while immensely more knowledgeable than the character, is still fallible and not guaranteed to be reliable either.
Though I've read a few that tried 2nd person perspective, I've never been impressed, finding it INCREDIBLY annoying
So have I. I think the only medium that really tolerates second person writing is love letters, or maybe personal letters in general. Notice, those assume very specific reader. For a general reader, it's incredibly difficult not to make assumptions and decisions for the reader (and perhaps completely defeat the purpose and narrative if the author doesn't) thus taking the reader for a forceful ride they are very unlikely to accept. It perhaps could be framed so the "You" point to a predefined character and not directly the reader, but again, that's perhaps not most attempting it are trying to achieve.
In Latvian, there's a verb form, mood, that combines uncertain indirect knowledge reporting, future tense and necessity, and can work in second person (or any, the form itself doesn't have neither a person nor gender). Perfect for, say, relaying what a person might experience during a medical procedure or some such, yet even that becomes annoying beyond a few sentences, for being a quirky compound tense if nothing else. Yet I imagine it could be possible to write erotic scenarios in that way...
Approximation in English would read something like: "...reportedly, there will be a room on the right. You should go in there. You may meet a man, he probably will make you undress..."