i usually will use a cheat when either, A. im stuck and a cheat may help me, or B. a harmless cheat that will just help me out when i want to use it.
But, i have some conditions on what type of cheat i will use. I will NEVER use a cheat if it permanently change stats (Health, magic, defense, bla bla bla.) The exception to that condition is that if it is for gold or something which i use very often (Mabye like press R to refill rockets, hold select and L for 99999999 gold) and it drains itself, then i will use it, but only if i feel like using it. And i also will not use a cheat if it progresses me further than where i currently am, such as in metroid prime, if it skips me 4 worlds, then i will not use it.