I've heard a few conflicting theories and can think of a couple more:
Unfortunately, I can't find hard data on if/how the use of console commands affects the unlocking of Steam achievements. I've painted myself into a corner and am forced to choose between abandoning a couple hours' progress or cheating my way out of it.