If SteamWorks achievements are present, opening the console will probably disable achievements for that character from then on (you can always just reload and not open the console to continue to get them.)
So if you like getting achievements, there's an incentive.
I'm a complete [censored] for achievements so that is actually a big incentive for me.
When I was younger I cheated all the time in games. I still remember all of the weapon cheats for GTA SA and all of the resource cheats for Age of Empires 1 and 2. As I've matured I realized one thing, cheating makes the game dull. Simple as that, I don't cheat because its more fun not to and there's more satisfaction. The only time I ever use the console in Fallout or Elder Scrolls is when the game won't let me progress because of a bug. I have never used the console to raise my stats, two examples of what I use the console for, both in New Vegas:
Spoiler 1- I brought law to Primm meaning people start exiting the casino. The trader(Johnson Nash) walks to the middle of the street and stops, this is a problem since I can only trade with him if he's in his store. I look on the wiki, find the solution, use the console to kill then resurrect him and he now walks into his store and I can trade with him.
2- There's a huge and intermittent bug that involves companions, weapons and casinos. I left both of my companions outside of a casino, went in and saved a few times, came out and found out that the weapons I had placed in the inventory of one of my companions(Cass) had disappeared. These were weapons(Oh Baby and a fully modded Holorifle) I needed so I used the console to put them back into my inventory.