I liked the way EQ2 did player housing. The player bought either an Inn room like in the OP but these dad a few different floor plans and it changed depending on the city you had it in. They also added larger houses that either came as a extra for buying the xpack, or finding the deed to it in game, or the super fancy ones on the store. Players could find house items in game as drops, some professions made house items, and there was a market store where players could make and design their wares and sell it on the store. The player would make some money and the game took a cut off the top.