Packing for Mars
There's a book by Mary Roach called "Packing for Mars" which discusses living in space.
It's the only such book I know that's NOT been written by an astronaut or space enthusiast, and it has a really level headed, open minded look at things.
It discusses all the downsides and all the upsides. Like it's really hard to find things in zero-gee... for example, on Earth a pair of pliers can be on the floor, or on a table, and it will be laying in one position. In orbit, it could be ANYWHERE or even floating in mid-air, and it'll be in ANY orientation. Turns out the human brain has an incredibly hard time dealing with this. Astronauts come to realize they've been looking right at the object they're searching for, for hours, and not recognized it.
Basically, at the end of the book, she sums it up like camping in a remote wilderness. It's a pain in the ass, its dirty, it's dangerous, and you forgo a lot of comfort, but boy, is the view worth it, and you learn things about yourself and the universe around you.
Really worth a read.