I'm a necessary cheater. Basically if the purpose calls for it, the cheat is easily forgivable.
Examples:
Save-scumming for the purpose of if something completely BS and not fun at all (or embarking to realize you forgot a thing or 2) happens.
[CAVE-INS:OFF] for making constructions that would be independent from the land (floating cities, airships, etc.). Bloodfist being a great example. Of course, the cheat is only limited to the assigned area (in this case, the shipbuilding). The rest of the playing field must be played as if cave-ins are possible, and some gameplay is compromised (either more or less fun) depending on what's involved. In my most recent case: I have imps coming out of the magma pipe, and because I have cave-ins off, I can't drop a stone pancake on top of them. Alternative, however, is a sacrificial pit which doubles as a tomb and "Sealed Evil in a Can".
And if I'm tinkering around with Raws or design ideas or experimenting all sorts of things, I mess around with the Reactions chart, or embark options/values, and give myself all sorts of material I need.
But of course, the most common cheat I use is the VisFort reveal. It does the job of Reveal, but doesn't compromise my save, but it's mostly for stone color purpose. Any fun stuff found is usually accidental. It's how I found the remaining light red stones to finish the fist emblem on the ship.
Alternative, but more used as a tool is either DwarfCompanion or DFTherapist. DF Therapist is more often used for it's user-friendliness, and mostly to monitor stats and skills, and mass-assignment of jobs. Other than that, I don't really cheat with it. Just a better way to keep track of things.