Yes, castling is overrated, but still nevertheless important. In one of my recent games I even moved the queen bishop before castling because there were lines where if it was attacked then queenside castling would be ideal because of the open g-file (this didn't actually happen).
Principle of flexibility sometimes contradicts advice saying to castle early, and most times we should, but if we traded down into an endgame then castling is a mistake as your king is now farther from the center. This actually happened to me years ago, and right after I castled facepalmed myself (moving too fast was a problem for me then) for stupid hand weaving (though I didn't know that particular term back then).
Heisman also calls blindly playing a move off a general principle "hand weaving", especially when there are concrete tactical variations to work out. When there are that's when we should make a positional assessment of all the lines we analyse and determine best capture that way.
Short answer: Of course it's not worth it to sac a piece just to deprive an opponent of castling.
But the longer answer is that it's often very desirable to sac a piece to keep the king in the center if you already have a decisive lead in development. There are many examples of such sacrifices.
But 1.e4 e5 2.Bc4 Nf6 3.Bxf7+?? isn't one of them.