60GHz is more of a PTP or PTMP use case spectrum i.e. outdoor, long range, high throughput, but requires line of sight.

I have an enterprise style network stack like you described, albeit a bit more. It allows me to be dedicate a single spectrum per SSID e.g. my IoT network is only 2.4GHz, or use multiple spectrums across multiple access points for a single SSID e.g. guest wifi uses 2.4GHz & 5GHz across several across points for roaming.

I also live in a location where that's required, or at least, warranted do to the coverage area and physical layout.

So with that said, you can't future proof yourself with an AP, as standards evolve and change - but you can somewhat protect yourself by running the right cable (Cat 6a). Regardless, if you're just trying it get wifi in two rooms, you probably only need a single access point, but far be it for me to lecture someone on excessive home IT spending.