It's just like any other dream - it has upsides and downsides. I wouldn't trade it for anything else though, and I can't imagine moving back into a small box in the middle of a crammed city. If you're a bit of a handyman and know what to look for it doesn't have to be that expensive. I've written half an e-book on how to find, buy and live on a boat. Hopefully I'll get the rest done this summer.
An old IBM R40, some Philips monitor I got for free and a great view.
Pic of workspace: http://maximise.dk/workspace.JPG