ie: the main character finds out that everybody else is an actor and everything aside from their own actions are staged. My personal vote is that it would be pretty funny for Death Note to end like that
One kind of interesting twist on that is Fincher’s The Game. It remains unclear until the very end of the movie whether the main character is in a convoluted game where people are pretending to conspire against him, or an actual conspiracy using the game as cover.
I would disagree with that being a plot twist, though. You’re aware of both possibilities from very early on, and the idea that it’s real appears later than the idea that it’s not. It’s hard for it to be a twist when people keep directly telling you what the twist is going to be before it happens.