I use cheats a lot to fix game glitches (resetsim) and to fix relationships the game messed up.
I used to be strongly against bb.moveobjects on, but I've recently discovered how much fun it can be! So now I use it a lot. :) I've just started to play with the debug objects. I don't cheat for the award objects.
I never use mood cheats, but I have a lot of decor objects and other in-game things to improve moods.
I use freerealestate on a lot. I love having my Sims start with cute houses. But then I cheat to take away all of their money usually, so they have to struggle to pay the bills on their cute new house. I rarely give them more money, but I do have a very rich character that I had to cheat a lot of money for.
I'm using cheats to try to control the unruly NAPs in my worlds.
I use cheats to change the traits of Sims I download from the gallery. No evil Sims are allowed in my world (well, except for Vlad). :)