Fixing Up

I recently read that not only is it best to get a home in the better area (even if it's not an ideal home), but it's also not worthwhile to improve a home to a degree that is better than the homes around it. I guess those two points go hand in hand. However, it's upsetting to buy a home and not be able to fix it up to the point that I feel comfortable and content in it.
Any suggestions?