"The real question is; does the convention of yandere storytelling even allow for a straight-up happy ending?"
I mean, literal Gasai Yuno canonically got one (in Redial). This seems relevant.
I mean, literal Gasai Yuno canonically got one (in Redial). This seems relevant.