It's a lot of money (5000, and another thousand or so if you want to make it look like less of a hovel). The bed didn't serve much purpose for me, as I already had a bed with the Companions (if I'm remembering their name right), and even just staying at the inn is more cost-effective the first 500 times you do it.

The one real upside of having a house is the storage chest that I can use for stuff I kinda want to keep, but don't want to weigh me down. Ingots that I don't know how to use yet, weapons that aren't good for me but might be good for followers, that kind of thing.