I have to agree with Lakeview Manor. I just really like the setting and it's got everything I want in one place. I built the kitchen, alchemy tower, and greenhouse. Have a smithing workshop in the cellar. People talk about it getting attacked a lot, but I haven't had too many problems yet. Before the house was finished I had a giant snooping around. I hadn't built the animal pen yet, and he was just staring at the spot it would be. I think he would have left me alone, but I got up on the roof for some reason to get a better vantage point on him and accidentally fell right on his head, so he attacked me. Other than that, I've had one skeever infestation, but nothing since I've moved my wife and kid in. Just got a chicken, so we'll see if anything comes after him haha.
All in all it just depends what setting you like and which town you want to be closest to as all the houses, for the most part, offer you the same options in terms of rooms and extras you can build.
I just feel like Lakeview is a place my character would actually choose to live. There are some strange things about it, like the mage hanging out just behind the house ? Found that a little creepy, but just killed her. She respawned once, but now seems to be gone. Also, there's a little hunter's camp on a little island in the lake by the house which I found comforting for some reason haha.
As for decorating, I put a few things into the house, but now I'm just paying my steward to furnish the rest. Takes her some time, but it's fun to come back in to the house and see which new things have popped up.
I personally love Hearthfire. Whichever house you choose, the main thing is you'll get to have so many useful resources in one place which is really cool.