Frankly, I am dismayed that this house is more expensive and not better at all than the one in Whiterun. Had I investigated the house after purchasing it (before doing a bunch of thieves quests) I would have reloaded and not sunk the gold into it at all.
Why does it suck?
Absolutely no practical storage in the basement. The Whiterun house has a satchel right on the alchemy station for ingredient storage. It has a chest right behind you for finished pot storage. It has a book case right there for storage of the recipes.
The Rifton house has NO storage anywhere near the alchemy station. It has no storage near the enchanting station for your soul gems and items to be enchanted.
Its well away from shops and vendors where you would normally be selling things. Rifton has only one blacksmith (unlike Whiterun that has 3).
The only thing it has going for it is that the thieves guild HQ is there in Rifton and that the house has an external (out of town) entrance you can ride your horse right to without tipping guards off if you have a Rifton bounty.
It does have working weapon racks and wall racks unlike my Whiterun house. My Whiterun house's racks are not clickable, apparently glitched as my granddaughter's Witerun house works just fine.
I do hope the other city houses are better than Rifton's but I damn sure will be making a save before purchasing them and then investigate them thoroughly after adding the upgrades to see if they are really worth keeping.