If we are talking about the original Bioshock I can provide a competing perspective. I found the story to be extremely mid at its peak, and actually mind numbingly poor at the great moment of reveal. I literally fell asleep multiple times trying to get through the game. So if you are not vibing with it in the first 1/3 of the game I think there’s a good chance you just won’t.
I’m really glad that so many people loved this game. There are many different kinds of stories that work for many different kinds of people and this one works for a LOT of people. It has an amazing aesthetic. But it didn’t work for me.