The plan is that we (my wife and I) will buy the property.
Then you will also be the owners of the property. Your son owns nothing.
We split the costs for the house 50:50 with my son
Then you remain the owners of the property and additionally of the house. Your son still owns nothing, but he has debts.
The usage should be like this: garage and ground floor apartment by us (rental), the apartment on the upper floor by my son, owner-occupied.
Thus, you will be landlords for both apartments for tax purposes.
If he no longer wants to use the property, there should be the possibility to sell to us (right of first refusal), sell elsewhere, or rent it out.
That is not necessary since you are already the owners. Your son is basically the tenant.
The son is 24 years old and should have an economically viable and still flexible start into the real estate world.
Your son gets pushed into financing part of the house at the start of his real estate journey but has no assets to back it up. Not a good start.
We are looking for a solution for the son that is financeable through a bank and causes as low costs as possible.
The bank you mentioned has already offered the solution. The son gets a loan and the entire house (= your property) is liable for it.
Conclusion: An unpleasant situation for the son who gains no benefit and co-finances your house. For you, it can become unpleasant if the son can/will no longer pay and the bank can force the sale of the entire house in foreclosure.
More expensive, but clean, is to divide the house into condominiums so that each party only has to finance their apartment. I suggested that from the beginning.