Is Bioshock Good?

I just watched this vid from gamespy http://www.gamespy.com/articles/828/828805p2.html and it looksamazing! i didnt think the game was great till i saw that vid and now im into it, unfourtunatly i dont own a 360 cuzi own a ps3, but there was a little file that leaked out of the computer data that had the console ps3 written on it so there is a little hope for me, but other then the video is the game it self any good? how long is the story?

the game is awesome, but if you get it now...do you think you'll have enough time to play the great games that are coming out soon? CoD4, AC and mass effect

those are all worthy games to get in nov