I believe that many people do not actually calculate this investment as such but rather the question is: can I afford it (possibly with compromises) or not. And if yes, then just go through with it.
Yes, definitely. No one who critically calculates this could take these houses. Nevertheless, they were gone after a few days. There are plenty of people who could still afford it, but being unreasonable is easier with low interest rates. 1.5 years ago, a house like this with a 1200€ installment was still feasible. Now it rather needs about 2000€, and whoever can afford that money might want something else. Although money does not necessarily mean a newer property. leschaf is an example where the property will hardly pay off and yet an incredible amount of money is spent. But he can also afford to be unreasonable ;)
Currently for sale in our community: "Exclusive" new-build condominiums. Location: In the middle of nowhere. Highway 25 minutes away, many small villages, 1 hour driving to the next real big city. Six parties in a (admittedly really exclusive and nicely designed) multi-family house. Air-water heat pump, KfW55 standard, tiles and vinyl floors, elevator, balcony/terrace, barrier-free - garage or parking space is added additionally to the purchase price. Price for 93 sqm: 325k € - approx. 3,500 €/sqm. Price for 104 sqm: 395k € - approx. 3,800 €/sqm. Wow ... I am really curious if they will sell at that price.
I just looked in my hometown. Small town in the Upper Swabian province, 8,000 inhabitants including all districts, otherwise fits quite well your description. New build apartments are listed there at 4000€/sqm. But there are not many left.