I found every Bioshock game game me slight motion-sickness, especially if I was watching someone else play...but no where near as bad as the Halo games. I became motion-sensitive to FPS games after Turok on the N64 so I pretty well stayed away from them until the first Bioshock. Oddly enough, I can play Borderlands all day without getting dizzy at all.
I loved all 3 games' storylines but I guess I'm just a sucker for Bioshock.