We bought a "young used" property. Our conditions were somewhat similar: no craftsmanship experience, little time for own work, and a foreseeable parental leave approaching. During this time, we had to tighten our belts considerably, especially towards the end, when we didn't have a childcare place (despite legal entitlement) and I therefore stayed at home a bit longer. We were therefore glad that we had not financed to the limit.
We didn't want a renovation project – not reliably calculable for us in terms of time and money. New construction was also out due to the costs, especially since there are hardly any plots available, and if there are, only at absolutely insane prices. The young used property was practically move-in ready, and we are gradually redesigning it; so far, these are only cosmetic/practical changes and therefore financially manageable. Of course, this means compromises in the "B-note": the equipment was not quite what we liked, and not everything on the outside was like our dream house. But you have to make compromises somewhere if you don't want to overstretch yourself, and except for the location, almost everything can be changed.
Maybe you should focus on something similar in your search? We gradually adjusted our criteria: from detached and condition from-to, to: maximum 10 years old, enough garden space, but a semi-detached house instead of a single-family house was also possible. After some searching, it then worked out in our desired location, of course. If you are not under time pressure, I wouldn't buy a compromise house, but only one in which you stand and feel "this is our new home." Our house was the only one during the search that immediately felt like us, apart from the matching key data. Therefore, I wouldn't just go by the pure numbers and facts, but also by feeling. After all, it is your own home.