Basically, you can and should do whatever you want.
The house that fits the life situation.
I currently don't see any other life situation here. The child is currently 15, will move in at 16/17.
that’s why we came up with the idea not to build a two-story city villa this time, but a house that we can also live in and manage without kids and all.
In a house of about 100-120sqm living space. I bet with you: when it comes to the planning, it will end up being 140/150sqm again. The child needs space, will live with you for quite a while longer, you can’t plan that away or reduce it. Or rather, I can’t imagine that you do that.
For me, you are 10 years too early. I think the desire to change a house may have other reasons. I remember a thread with a plot near a nursing home...
But an actual need for change becomes interesting when you have health or physical changes due to age. You can consider some things now, but the “wish list” at 60 is truly different than at 45. Few admit it, but unless you feel like you’ve been run over by a tractor at 45 or 55, or you get the chance to change, you don’t think about this or that.
But while I write this, I think you could probably build a current kid’s room so that it can later serve as a second bedroom. However, there will probably still be a need for an office since about 20 more years of work play a role.
About the residential area: nice surroundings. Personally, I would pay attention to the mill view and would not want to live between two two-story houses if the plots are as big as they are. The prices are crazy though!