I can compare it relatively well in our case, as we have built quite close to the standard compared to many others here in the forum.
In 2014, we completed a small house with 125m² of living space, a 50m² steel garage, and the outdoor facilities on a 525m² plot. The whole thing cost around 300K€.
Equity 85K€
Loan 215K€
If you spread out the annual special repayments, we have a monthly rate of 1530€.
Remaining debt after 10 years 61,000€
If you roughly calculate what the house costs us over the 10 years, that would be
Equity 85K€
Installments 183.5K€
Reserves and non-allocable costs (estimated 250€/month) 30K€
=298,500
Against this stands the value of the house of 300K€ minus 61K€ remaining debt = 239K€
In this residential area, several houses of similar size, age, and equipment have already been listed with cold rents around 1200€/month online. That amounts to 144K€ rent over 10 years.
As tenants, you would have a surplus of 580€ between a rate of 1530 plus 250€ reserves and the cold rent of 1200€.
If you invest this together with the 85K€ equity, after 10 years at a 4% return you would have 212K€, at 5% 230K€, and at 6% 250K€.
Assuming the house is not worth less (which is unlikely given the increase in land prices from 80€ to 200€/m²), we would have had to achieve a 5-6% after-tax return with the capital.
Rent increases would further improve the result in our favor.
A consideration period >15 years would also have a positive effect in favor of ownership due to the elimination of the installment.
For us, it was definitely worth it, assuming that we as tenants would also have chosen a house.
This may look quite different in other regions, with different repayment rates or at different times.