Rapture uses a scifi apocalyptic premise to tell personal and intimate stories of the inhabitants of an idylic english town, problem is it goes out of its way to be as vague and mysterious as possible about it. On the surface, it doesn't sound much so the best way I explain the problem by comparing it with a tv show I recently watched called Broadchurch.

The show is a who dun it murder mystery where the dirty secrets of an isolated town are dragged to the broad day light as the investigation goes on. There the mystery is the hook and every detail revealed adds to intrigue. But make no mistake, it is primarily a drama of inhabitants. The show makes you want to know about the characters, and when you do, it's their struggles and pain that you care about over even the mystery.
Now Rapture is similar case, but the hook is vague and kept mysterious. The characters are faceless wisps of light where little dialogues snippets are drip fed to you in potentially (most likely) non linear fashion due to how the exploration is structured. Not only is it hard to keep track of who's who, but the dialogue is of mundane variety. Very little of it adds to overarching mystery, serving more to form a vignete of a group trying to deal with apocalypse that anything concrete. It left me with little reason little reason to care about anyone or what happened to them and that is why I stopped playing.
I can see how some may connect to this form of storytelling as it is a pretty game with great VA and soundtrack. The use of light to guide you and the solitude that comes from the lack of information helps to project your feelings and ideas on to the story. Maybe I could have gotten more out of the story if I finished it but I already played more that I wanted and I don't want to indulge in sunk cost fallacy.