Put at least 2 ports per room with CAT6.

Well, maybe some info would help?

1. How many floors?
2. Distance from your IT rack?
3. Budget?
4. Considered mesh wifi or powerline?
5. Number of data points?

By the way, "best and for the future" is very vague. Do you want the most expensive stuff or most high tech equipment available in market?

Without knowing much about your house and your requirement, don't expect to get a good recommendation from people.

Dintek is not bad, the link which u attached is 23AWG cable, good spec, it can even run 10G in short distance, and good for PoE too. And don’t forget about the connector, many reno sifu will only use cat5 connectors, it’s better u get cat6 connectors for them to install as well

Go with the suggestion, 2 port per room/termination point. If planning to upgrade to 10gb, then use cat6a. Go for branded cable, Dintek, Plenum, Hubell. Less headache next time.

I assume there is a machine to run Unifi controller app. A Raspberry Pi will do.

I also assume the 3 UAPs are going to be ceiling-mounted.

If you want DPI on your network, you need USG over Mikrotik Hex.

Looks good to me.