For anyone interested I added some notes about increasing the room wealth to the analysis section. I used dev mode to create 2 6x5 self contained rooms (so no openings to anything but each other) with granite walls and paved tile floors separated by 2 wooden doors and then one ornate wooden door.
With the 2 wooden doors the rooms stats were: Impressiveness 23 Wealth 263 Space 34 Beauty 0.0
and with the Ornate door both rooms stats were: Impressiveness 44 Wealth 828 Space 34 Beauty 0.94
So they do actually provide a noticeable boost to both rooms.