This is wonderful just2be and all you guys who have contributed. Question: is there a list of objects and what their exact emotions/auras are? My sink has an aura, my fridge does, my coffee maker and there are more. Some are obvious, some are already listed, (reward lamps), and some are just big mysteries. I'm trying to make mood rooms, like all inspired stuff in the kitchen, or mood areas, but having a hard time wrapping my head around all the items. Like, I know if you play chess you get a focused emotion but what about something like the card table?
A quick summary from what I've learned about decorations/room design. You can get anywhere from +1 to +3 moodlet for both happy and one other emotion in the same room.
The happy moodlet depends mostly on the level of "Environment" in the room, but it works a little weird. If you put a single item with environment 9 or10 in the room, you get a +3 happy moodlet. If you use +6 or better, +2 happy, +3 or better +1 happy. You can also combine multiple lower value decorations to hit that +3 happy moodlet, but if you do it actually requires more Environment total (like two environment 7 decorations or so). Therefore, the easiest way to hit that +3 is to throw in an Environment 10 painting, or one of the armor statues, then decorate the rest of the room as you think looks good.
The other emotion (focused, inspired, confident, ect.) depends not on the level of the items in the room like happy does, but only on how much there is, so if you want to get +3 confident, for example, the most efficient way to do this would be to paint 3-4 masterpiece paintings, as each will give +9 confidence aura. You can do similar or better things for the other emotions, a lot of the high-end career rewards give great auras, but IMO the most efficient way for every emotion other than focused and inspired is just to paint a number of masterpiece emotional paintings. If you are just starting out, you can stack a TON of low level emotional paintings for the same effect (I know that 5 "good" focused paintings turned into +2 focused).
There's a great guide to how those emotion auras stack up on Carl's guide site. Now I know it might seem like I sidestepped the question a bit (as you wanted to know what items can give what emotion) but consider that you only need +8 of an emotion to get to Very Happy, Focused, whatever. So with +3 focused and +3 happy from the decorations, you only need +2 more to hit that break-point. You can pick up a permanent +1 to a room with the "Let there be Light! - Laser show", this item is amazing, its only 375 Simoleons and it gives a +1 moodlet to any sim in the room, more or less. Sometimes its a little line of sight picky, but that's easy to avoid. After that, the last +1 is pretty easy to get and maintain, just look at an emotional painting once every 4 hours, or listen to music, or buy a trait that gives you +1 happy at night, take a shower, eat some food, ect.
My point is, while its handy to know what items can give you bonuses to emotions, you can easily hit and maintain +8 to an emotion by stacking 2-3 of a high value item, and without having to worry about which items exactly give what auras, just hit that +3 aura and then decorate the room the way you like!