Stockfish is nearly always right in non-endgame situations, but as with any computer, what is right for a computer is often not right for humans.
I used to try and use Stockfish lines exclusively, and in general, it's not a bad idea.
However, a most common computer-type move that really should be considered an 'error' by humans is whent he CPUs go for unnecessary tactical complications. It's not unusual to get a winning position against a human opponent where you might be one, even two pieces (or pawns) up and thus have an easy risk-free win just by either trading down calmly or restricting enemy counterplay patiently.
However, the computer will ALWAYS go for the fastest tactical kill if one exists. Meaning, even if you're up two whole pieces and could win totally risk free by taking more moves, if the tactic is there, the computer will recommend you sac your Q, R and R, to get that one super complicated winning line in which one false move means you go from totally won to totally lost, because the CPU never errs in these tactical situations.
It took me awhile as a beginning player to learn that you can't trust the computer for best play in a lot of positions because of this, and you still have to use your judgment as to whether the CPU's line is playable by humans or simply too risky in terms of leaving you totally lost if you make even one slight calculational error.
I've started to become really distrustful of engines. To the point where I'd rather have another human check my analysis than the iron beasts. There is a few reasons for this but one of them an increasing cognitive dissonance with the way computers think. I used to be really in sync with them, now I almost feel like I can tell when they are wrong and right, and its never when I think I am wrong or right.