I've used the console for three things, none of them cheating. They are:
I used the 'remove item' command on Lydia to get rid of her damn bow. I would have to count the fingers on both hands the times I've died charging into combat thinking Lydia was by my side, only to find out that she opted to hang back with her bow and avail me nothing by missing the enemy or doing the most minimal damage possible. Grr. All that console command has done has turned her into a pure-warrior character like me.
The 2nd one I have done, is lowered some of my skills. I like to role play in my game, so having a pure-warrior Redguard who hasn't touched or studied magic at all in his life, have a destruction skill of 15 is highly... silly. So, with the 'player.setav' command, I simply lowered all the magic skills, alchemy skill and pickpocket skill to 0. So, if anything, this was the complete opposite of cheating.
The 3rd and final command I have done, is a couple of 'disable' commands every now and again. As previously stated, I love to role play in my game. A part of that, is seeing the roads clear for travellers. Whenever I kill something on the road, I drag their bodies to the side to keep it clear (if they were men, mer or beastfolk, I drag them out of sight of the road). Dragon skeletons, of course, can't be dragged, so they are slab-dab in the middle of often-used roads... forever. So I use that command after an in-game day or two to get rid of them. I also use the command when I come across something I killed a long time ago, and get rid of it (as role-play wise, they would have been eaten or something by now).