I'm not really the best authority on this topic as I'm still quite new to weebdom (and I didn't look at the spoiler tag) but just chiming in with with my opinions in regards to what others have been discussing:
For me, realistic characters or situations have never been important in otaku media. Starting from their looks, with almost every girl drawn as asthetically pleasing as possible, a realistic approach isn't what most authors in this subculture seem to have in mind (with a few exceptions, such as Evangelion. Interestingly enough Shinji seems to be quite a controversial character precisely because of his realistic portrayal). From what I've heard, the speech patterns are also quite distinct from what you'd hear in RL Japanese and oh god, those voices and mannerisms would be absolutely obnoxious in real life. Like someone else above mentioned, I'm drawn to anime/manga/visual novels as a means of escapism, to be engrossed with quirky characters, teenagers saving the world, and life-defining highschool crushes.
These are works made by otakus for otakus and influenced by other works of otakus rather than the real world. But I don't think that's necessarily a bad thing, it's just how these tropes are presented what matters. In fact I think one of the strengths of this medium is how they can present deeply engaing stories with characters and relationships I actually care about and can emphasize with despite their unrealistic nature. So if you come with the expectations of finding a realistic portralyal of interpersonal relationships, Japanese school life, or teenage drama, you will probably end up disappointed. But that's not how these media were intended to be enjoyed in my opinion, and if I wanted realism I'd just pick up a book.