Its sister series, Umineko: When They Cry, is even worse. The plot (at first) is about the main character trying to argue that magic does not exist... to an apparently very real witch. Who claims to have killed him.
When They Cry in general is a huge Mind Screw because of Rika Furude and Frederica Bernkastel, though it's confirmed that the witch Bernkastel in Umineko is an amalgamation of all the Rikas who never made it past June of 1983. Well, that and the whole issue with cranking Unreliable NarratorUp to Eleven. It's now official that you can't trust anything but the parts Battler's narrating in episodes 1-4 and the parts Erika's narrating in episode 5 of Umineko, and Higurashi had entire arcs narrated by people who were hallucinating.
The main feature of the Infinity series.
Never7 is an odd example- the game's first four routes appear to be part of a fairly straightforward romance Visual Novel with some mystery and supernatural elements. However, the game's fifth route reveals that the entire game may or may not have been a delusion, some elements that were previously explained with supernatural elements are cast doubt on (as they may also have been caused by the delusion), that other character were possibly having delusions within delusions... in the end, the game concludes ambiguously, leaving it up to the player's interpretations to decide how much of the story was a delusion and how much was real.
Ever17 in increasing amounts as it becomes increasingly obvious to the player, if not the characters, that things just don't add up. They manage to explain it all into a single continuity even but until then you may have to pause to ask yourself things like... actually, explaining the mind screwiness would actually be spoilerific. There are a few strings dangling.
Well, at least Ever17 explains almost everything. Remember11 takes it completely the other way; some of the mysteries are solved around 2/3th of the game, but as you reach the ending, more and more mysteries are added, with the game ending with a plot twist that came so out of the blue for some, that many people completely hated the ending. (The fact that even the answers given were so confusing that many players didn't even get those didn't help either.) The game will then confuse you further as you have to try to see every single confusing bad ending through its confusing ending system (would take too many spoilers to explain), and finally rewards you with the final TIPs, which theoretically would allow you to solve the game. Needless to say, to this date, nobody truly knows the solutions to the mysteries presented.
Nine Hours, Nine Persons, Nine Doors. Akane is dead, and you've been playing as Akane nine years in the past this entire time. The whole purpose of the present-time Nonary Game is to save her life... nine years in the past.