cpu overheat

Hi, I am hoping for some good advice. I have one general question and then one specific related to the general. The general question is, when is upgrading a PC not the best path and replacing a system needed? Is there a price or performance point? Seems like you can always keep piecing but...