I use moveobjects and showhiddenobjects all the time when building. I also will use the money cheat and the cheat to fill needs and disable their decay when moving in a tester Sim for builds. I also use headlineeffects off when taking screenshots. I have used cas.fulleditmode to fix disasterous looking townies and sometimes when one of my Sims ages up in an unfortunate way. I have used the cheat to change Sims' career outfits too if they come home in some outlandish get-up. Lastly, I've used the enablefreebuild cheat on hidden lots to build on them.
When the Never Needs Sleep reward trait was borked a long time ago and before they updated reward traits, I would use the fillmotive cheat on a Sim who had bought that reward whenever their sleep need went down. I didn't see it as cheating though, just allowing my Sim the perks of that reward as originally intended. I don't use that one now though.
Sometimes when necessary, I'll use the resetsims cheat when they are glitching/bugged. That happens rarely in my game though.
So yeah, I use cheats, but not excessively in gameplay, mostly build mode. Plus, they're all in-game available from testingcheats. I don't have any gameplay enhancing Mods and never have had any.
Happy Simming! <3