I work at a network VAR and I'd say this covers 99% of anything you'd need to know for home Wi-Fi, albeit it's a bit of a long read as a result.
It's very well thought out and the only qualm/pre reading tip I'd have with it is "it was written a couple years ago then extended over time". Practically, this means when it starts out talking about how your devices are the problem you should start thinking about "how many of my heavy data devices are laptops or phones already 6ghz capable or could easily be made to do so and what would it look like to connect them in my house" and keep that as the priority in your head as you read the rest of the article.The article eventually mentions everything you really need to know to come to that thought but you may have already come to conclusions on trying to solve it via optimizing the legacy bands before you get there.
Once most of your heavy data devices are doing most of their traffic on 6ghz, optimizing the rest of your network/bands becomes anywhere between not needed to much more feasible (which depends largely on your physical environment and how many heavy clients you were able to put on 6 most of the time) so you may not need to do anything else to enjoy gigabit Wi-Fi speeds.
I guess the other bit I'd list the mentioned tri band 2.4, 5, 6 GHz mesh systems don't have a "dedicated backhaul". Instead of buying one of the above 2.4, 5, 5 tri band radio mesh systems for IP to twice the price you can just as easily not connect clients to the 6 GHz radio on the other mesh APs and you will have a "dedicated" backhaul that (almost certainly) performs better than a dual 5 GHz mesh solution while also leaving you more 5 GHz bandwidth available. Still listen to the advice to avoid mesh if you can though :).
One last "fun" mention: If you want to splurge just to have it those TP link (pre finalization of) Wi-Fi 7 routers are really quite good and if you can get coverage and device support right in your space 1-2 Gbps as the typical goodput is feasible. If you want more than that for some reason there aren't any "practical" answers right now.
It's very well thought out and the only qualm/pre reading tip I'd have with it is "it was written a couple years ago then extended over time". Practically, this means when it starts out talking about how your devices are the problem you should start thinking about "how many of my heavy data devices are laptops or phones already 6ghz capable or could easily be made to do so and what would it look like to connect them in my house" and keep that as the priority in your head as you read the rest of the article.The article eventually mentions everything you really need to know to come to that thought but you may have already come to conclusions on trying to solve it via optimizing the legacy bands before you get there.
Once most of your heavy data devices are doing most of their traffic on 6ghz, optimizing the rest of your network/bands becomes anywhere between not needed to much more feasible (which depends largely on your physical environment and how many heavy clients you were able to put on 6 most of the time) so you may not need to do anything else to enjoy gigabit Wi-Fi speeds.
I guess the other bit I'd list the mentioned tri band 2.4, 5, 6 GHz mesh systems don't have a "dedicated backhaul". Instead of buying one of the above 2.4, 5, 5 tri band radio mesh systems for IP to twice the price you can just as easily not connect clients to the 6 GHz radio on the other mesh APs and you will have a "dedicated" backhaul that (almost certainly) performs better than a dual 5 GHz mesh solution while also leaving you more 5 GHz bandwidth available. Still listen to the advice to avoid mesh if you can though :).
One last "fun" mention: If you want to splurge just to have it those TP link (pre finalization of) Wi-Fi 7 routers are really quite good and if you can get coverage and device support right in your space 1-2 Gbps as the typical goodput is feasible. If you want more than that for some reason there aren't any "practical" answers right now.