Standard "make a sad dwarf happy" trick - if you've made noble rooms before, you simply make an extra 1-2 rooms for unhappy dwarves. Fill it with your decent but not best furniture - bed, table, chair, lever at a minimum but also semi-high quality statues, chests, cabinets, and what not. Designate two small 2 square food piles - one accepting only drinks (turn off everything but Plant Drinks, and also turn off (u) prepared meals) and one accepting only high quality prepared meals. Adjust the settings for each to "take from" your main stockpile, to ensure they are filled. And add a door. Do not use masterwork furniture.*
Once the "happy room" is built, and you have a sad dwarf, simply go to the lever, add a pull lever job, and hit (P)rofile to select the unhappy dwarf (he turns green, everyone else red). Go to the bed, chair, and table and (a)ssign the unhappy dwarf ownership of the room. Once they enter the room to pull the lever, lock the door.
Give them time, and the happy thoughts will accumulate from the nice furniture and meals. When they are no longer flashing the red arrow, you may unlock the door (they are unlikely to tantrum and harm the populace). Leave them assigned to the room and they will eventually become ecstatic, at least until you have a new unhappy dwarf to replace them.
* Why not masterwork or your best furniture? Two reasons. Because the room needs to be of lesser value than your noble rooms, or your nobles will receive massive hits to their happiness ("... was utterly traumatized by a lesser's living arrangements") Second, a miserable dwarf may tantrum and destroy things, and a destroyed masterwork is traumatizing to the craftsman that made it. So save the good stuff for nobles' rooms.