Looks great but I woud prefer to avoid Ubiquiti because I don't want to involve a 3-rd party cloud to manage it.

But I really appreciate your suggestion, perhaps I am going stick to it as I've seen no alternative so far and my previous experience with Ubiquiti makes me confident it will do the actual job great.

How about MikroTik hEX S 5 Port Router ?

This one seems suiting my preferences perfectly. I even wonder how did I overlook it. Now I'm looking for a WiFi6 access point which would work on the passive PoE it would feed.

You really helped me a lot! I wish you could feel how my mood has improved. Now I feel empowered to implement the set-up I wanted. This is a minor home improvement task but it sitted in my to-do list (after numerous attempts) for over a year.

No problem, I only became aware of this recently and it seems to offer a lot of bang for the buck.