On cable, you should easily achieve 500mbps as its gigabit ports. On Wifi though it depends on your house.
Does not make any much difference of having Wifi 6.
Suggest you look into Mesh Wifi but that also if you can connect multiple mesh unit with cable to increase the stability of the whole home wifi, then you will be able to hit 500mbps on wifi easily as long as your device is capable of WIFI 5.
I am currently using 2-unit TP-Lin Deco M5 for my whole home coverage. I connected it via Cable. Every corner of my home, easily averages at 480mbps. Cause there are some devices constantly running on the background so it is using the connection. But at times, i get full 500mbps.

Earlier my Mesh was running on wireless and stability is not great but still able to achieve average of 400mbps. But by having it on ethernet backhaul, the stability improved tremendously. And i use one of the port to split to a switch and connect my computer, laptop and printer on ethernet cable.
Definitely enjoying my 500mbps at its fullest. I have more than 20 wireless devices in used at the same time. Pretty much due to smart home as i have alot of those hubs and lights and etc.
So I'm guessing even getting 2xM9 PLUS connected wireless wouldnt help much to achieve 500mbps on 2nd node,i tried 2xM5 deco, i only get like 200mbps on the second node, which is no different than the 2nd node of my RE650, just that the RE650 takes a bit longer to switch between nodes