Best set up for new home

So,"best set up for new home" would be to run ethernet from a central location, where the ISP connection is, to all rooms with some runs to ceilings for access points. That's pretty hard in an existing house unless you are doing renovations. But the point is, wired is always best and wherever you can accomplish this, it's the best thing. (The general rule is, if a device has an ethernet port, then it should be on ethernet - this leaves the wifi for devices that need it.)

Mesh is for situations where the network cannot be wired. That's all it is - it's not magical or better networking, it's access points connected by radio. It's a compromise, but one that is usable provided the expectations are reasonable (many people overcome the radio throughput reductions by selecting a higher speed plan which will partially compensate.)

There are different kinds of mesh - like Eero where there is a "base" unit that connects to the ISP and is the router, and satellites or "points" that are the wirelessly connected access points. Another kind is the Asus you noted - Asus' AI Mesh is a system where routers can be connected in a smart fashion, and the secondary routers function as an access point/switch - also fairly easy to set up since Asus built in the smarts to make it all work together, like other conventional mesh (TP-Link is doing this with their OneMesh.) If you choose these, make sure all devices are compatible with their proprietary system name.

As u/mcribgaming noted, it would be a good thing to just get started with your ISP and then plan what you need based on analyzing what you can do with what's there, and what you might be willing to invest in. Low voltage installers can help you with running ethernet to places where it would help (example: you might decide to wire the office, but accept mesh in other places).

A couple of my opinions on other things you asked - I would avoid Netgear and Linksys, they are not the companies that they once were. Avoid any device that requires a subscription for software maintenance (a.k.a. firmware updates). There is also no need for "security" software with regard to the network (like McAfee and such). Also, my opinion about asking for best solutions at any brick and mortar retailer is only going to get you a recommendation for something in their limited selection. They tend to make what they have try to fit your need case, and the marketing on these things is crazy ("blanket your home in warm comforting wifi" is how it comes across to me). It's another situation where they are trying to make their product force fit into your needs. OK, 'nuff said. :-)

I think either you're misunderstanding what it means to be wired in with Ethernet, or I'm misunderstanding your post.

The router or mesh system you buy does not really determine whether or not you can wire your PCs and PS5. You need to have Ethernet wires run to these spots already. It's unclear if you do or not.

It's true you can wire something to the back of a remote mesh node, and it has benefits doing so, but it's not the same as truly being wired in directly.

I suggest you find out what you're working with once you move in. See if you already have Ethernet runs to different locations inside. If not, see if you have telephone outlets that can be converted to Ethernet, or see if you have coaxial cable run for cable TV that can be used for MoCA.

Then see if your ISP charges you monthly for using their equipment. If it does, then plan on getting your own. You hint that the modem is free, but often a "starter" router is also free, whether it be a combo unit or something like a mesh kit.

The answer to these kinds of questions will help determine what you actually need to buy. It could be you need to just buy switches, and the ISP provided equipment is free and enough for WiFi. Or that you have no wires anywhere, not even coaxial cable, and then a mesh system makes sense.

Just use whatever the ISP gives you for the first month. The time it buys can be used to make the correct assessment of your wiring situation and correct hardware purchases is worth it.