If I could live in Rapture, temporarily (like a few weeks vacation), before the plasmid chaos and be one of the few to survive and make it to a safe haven above the ocean waves, then yes. I think it would be a pretty neat exp. to live in the Ocean and see the giant squids and whales floating by. Then again, I'd be scared out of my wits about drowning and probably fairly claustrophobic since there isn't really any fresh air or sunshine. I can imagine a few people were probably going stir-crazy (cabin-fever) before they even started abusing plasmids, which turns my previous yes, into a no. lol
Regardless, the idea of it being a tourist attraction, or a permanent residence, needs A LOT of maintenance , upkeep and responsible non-corruptible people to help it along, and probably wouldn't be able to be maintained for a long-term period.