In solo/offline games, I turn to cheats all the time, be it FAQs/walkthroughs on the GameFAQs to figure out puzzles, mods or the occasional cheat code when a game has them.
For me, a game is more enjoyable if I'm not bashing my head against the wall. I'll try to figure out a puzzle in a game... but if it takes more than a few minutes, off to GameFAQs I go. I have too many games to play on Steam and too little time to play them. I just don't have the patience (or, once again, time) to be a purist. Without cheats, I would likely get annoyed and move onto a different game. Multiplayer would be different, because then you could ruin the experience for another player. But solo... bring on the cheats!