It's a really good Visual Novel series, with really well written characters and scenes. If you don't enjoy VNs/stories, I wouldn't pick up the game. Sure, there are puzzle rooms, but that's not the main point of the series. (As I was making my way through the second game, I was starting to get annoyed with the puzzles. I just wanted to get on with the story lol) Also, do not look up ANYTHING. at all.
The third game is a hot mess tbh. It throws out the VN part for "Cinema Scenes" which are garbage. Plus, the story portion is so jumbled up, it gets annoying, but I guess that's apart of the plot :/.