I can't really vouch for whether its a scary game or not, as I tend to watch the supposedly 'scariest horror films of all time/of the year/decade' etc and laugh at them.
You'll probably find BioShock enjoyable though. Perhaps don't play it at night with all the lights off? You'll be alright.
As for the people who said the gunplay was bad? Screw you. How can you possibly hate a game where you can fire a swarm of bees from your wrist to drive someone out of cover, electric shock them so they cant run, then get in close and shotgun their face off? Or crowwbow bolt them to a wall. To be fair, it did fail as an RPG but it was only ever supposed to have RPG 'aspects.' Don't expect to have some massive sandbox to play in like Oblivion or wow.
You'll probably find BioShock enjoyable though. Perhaps don't play it at night with all the lights off? You'll be alright.
As for the people who said the gunplay was bad? Screw you. How can you possibly hate a game where you can fire a swarm of bees from your wrist to drive someone out of cover, electric shock them so they cant run, then get in close and shotgun their face off? Or crowwbow bolt them to a wall. To be fair, it did fail as an RPG but it was only ever supposed to have RPG 'aspects.' Don't expect to have some massive sandbox to play in like Oblivion or wow.