When the narrator is lying to the viewer, it's unreliable. If they are in a state that makes reality skew, they are unreliable. If the reader can't trust the information given it us unreliable.
Stories like Umineko are full of unreliable narrators.
I can tell you a story but if the information...