Of course, a renovation can definitely be worthwhile, but you have to be aware that you are investing a considerable amount of money. And as silly as it sounds at first, a new build is much easier to calculate. I worked for several years with a property developer who eventually became heavily involved in renovations as well. So buying old buildings, renovating them, and reselling (condominiums). He did this very successfully for 10 years, so he had experience and accordingly professionals on his team. However, he ultimately stood on the brink of insolvency because a project that was estimated to cost €1.5 million in renovation expenses ended up costing €2.8 million. Of course, this is not the rule, but unfortunately, it can happen. Friends of mine bought a house 5 years ago (from the 70s, very well maintained), where it later turned out that volatile pollutants were used in the insulation (which was still flawless in terms of insulation value and appearance) that off-gassed indoors. Renovation costs: €65,000. There are simply many unknowns, so you have to approach it with an appropriate buffer. In addition, many people overestimate their affordable personal contribution and the time required for it. Of course, any reasonably skilled person can renovate a normal living space (laying flooring, drywall on ceiling and walls, wallpapering, painting, chiseling some cable ducts), but you have to keep in mind that this does not happen within 2 days AND a house generally has 5-10 such rooms.
If the location is of course great and/or the renovation will probably be significantly cheaper than a new build, then it is of course still interesting. Additionally, there are plenty of people who love the charm of older houses. And yes, there are also many renovated properties that have been excellently executed, but many of them say afterward that they probably would have built new for less or the same price. Especially with the size of bathrooms or kitchens, you often have to make considerable compromises in old buildings.