This thread has been a very interesting read - it's given a lot of insight into different play styles.
Personally, I use cheats mostly to fix bugs. The mailbox bug is a good example - if I can't get new omni seeds in the mail, I'll use buydebug to place new omni-plant starts if I have a Sim who's earned the ability to plant them. Resetsim also generally only gets used to fix glitch situations. I've learned how to avoid some of the bugs, but others I resort to the "cheat" workarounds.
I don't really consider the object placement cheats to actually be cheats, so I do use MOO and snapping off and free rotate pretty regularly in buy mode. I'm only just starting to do any serious building, but place frieze falls into that category for me, too.
That said.... I do use things like the Motive Mobile and moodlet manager pretty freely (once I've earned the LTR). And special powers of non-custom objects are fair game. I HATE the infant life stage, so I shamelessly drop those weird little grubs into a swing and walk away.
I will also occasionally use money cheats or freerealestate to set up a new game if there's a scenario I'd like to play that needs it for setup, but once the game has started it's very unusual indeed for me to go there.