I recently posted this in another housing related poll. I understand there are more important aspects of this game that need to be fixed before something like this would even be a good idea to start looking at. I am placing this here for the devs to potentially see and get feedback, etc from the community.

My dream housing situation:

You buy a strange trinket from the wandering merchants, when used it teleports you into a pocket realm of oblivion. Your quest giver is the daedric steward of this realm and he sets you off on a quest to kill the daedric demi god that owns the realm. (similar to the bad man hollows or whatever that DC quest/public dungeon was in Glenumbra) After you complete the questline (something like the size of Kenarthis roost in number of quests and time it takes to complete) The daedric steward becomes your steward and your quest reward for finishing this mini zone is that you get to choose what type of zone this place will mimic.

You now have your own pocket realm of oblivion that can have a house and other facilities placed on it and this is where the real work begins. To build your house will require X amount of gold and the materials to craft it, just like hearthstone did. This should be a process that takes awhile to complete. The pocket realm would have quite a bit to explore, but the actual building space would be divided up into six lots. A normal house would take one lot or you could go with a mansion that takes two. Once your house is completed you can then choose from a list of other amenities like crafting station (like on bleak rock, has all stations and a bank) practice dummies, stable (could show off multiple mounts at once and allow you to train your riding skill each day) etc. The idea with the lots is to make it possible to have a great house setup, but force players to choose and not be able to have one of everything that would be cool.

The zone could also have node spawns for ore, wood, etc but their respawn rates should only be every 24 hours or something similar so people still need to go out and harvest for their bulk in the world. Just like hearthfire, it could also spawn random enemies from time to time that you have to fend off.

For the sake of guilds you could also provide the option to make your home plot the guild house instead and it would allow members of your guild who have been given permission in guild perms to visit and use the facilities.

One of the biggest issues I have with ESO is that we are essentially homeless, the main faction cities don't really feel like hubs and most zone cities get abandoned as soon as you move on to the next zone. Having your own quiet place to handle the admin would be great. The housing would need to have access to guild and personal banks, maybe a vault that can't be accessed outside of the realm and everything else need for the day to day. This could also be the perfect place to post the daily quest boards for crafting writs and maybe eventually add in randomly generated quests.

Having all you need for your day to day activities in one place would be awesome, and having to gather the materials and gold to craft these things would keep me entertained much more than a new zone would. This also provides a perfect monetization avenue for ZOS as they could make furniture and decorations for sale in the crown store. I would also expect many options to be craftable by master crafters, I take no issue with ZOS adding the flashier options in the crown store. That gives them plenty to charge for without going down the slippery slope of P2W like so many complain they are.