
eero
Pro 6 Series
Easy, reliable, smart home ready; but paid features.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
I quite like the base model Deco sets and they do fine for lower/moderate speed setups. The M4 is dead cheap or the x something-or-othet is only about £180. Plus they're happy to be wired or mesh! When I say I like, I've installed them for a good few clients as a siple solution to good feedback and no issues to be honest!
Wifi boosters are a waste of time in my opinion. Mesh Wifi on the other hand can work very well. A great trick is to use the mesh stations as "ethernet extenders". I recommend a 3 unit mesh system for your house. Put one beside the modem and plug directly into the modem. Put one behind your TV and use an ethernet cable to connect your console (and possibly your TV) to the mesh unit. Put the third unit upstairs in a central location or in an office/study room if you have one. You need to disable the wifi signal coming from your modem to avoid wifi conflicts. If you have Sky internet and Sky TV this can be tricky to do because Sky TV force enables Sky wifi. There are work arounds such as making sure the Sky TV box is connected with ethernet rather than with wifi. I have used TP Link Deco mesh for years and find them excellent. Others recommend Asus. A wifi 5 system is cheap and good for 300MBs or so wifi speeds. I currently have a three unit wifi 6+ system and we are getting 700MBs+ wifi speeds and over 900MBs on devices plugged directly into the mesh units. I assume Wifi 7 is even better but it costs more. Just try to make sure you get a tri band mesh system so that you can use all three wifi bands (2.5, 5 and 6 GHz.)
This is exactly the set I have. Works great in. Two storey House.
To get the benefit of mesh you need two units. Plug one into your modem and put the second beside your PC and plug the pc into it with a short ethernet cable. Be sure to disable your modems built in WiFi and use the mesh WiFi instead to avoid clashes. Note if you have fibre to the premises you might not even need the modem. You can plug the master mesh unit directly into the ONT if you have the correct login details. The mesh units talk to each other and establish a very fast wireless link between units. It's not as good as a wired connection but it's the next best thing.
I switched from eero to TP deco and I like it more. Assigning 2.4 for IoT stuff is a great improvement. At one stage I was literally walking 100 feet outside to make my phone get to 2.4 because the eero cannot manually switch between bands. Deco WiFi 6 is great so far as long as you’re willing to fiddle with a few settings.
Your problem is simple. The router Spectrum gave you is weak, and it is sitting too far from your room. You do not need Ethernet in every room, and you do not need to touch the coax ports at all. Ignore the video you saw. You also do not want a “wifi extender.” Those cut your speed in half because they repeat the signal instead of creating a real network. Here is the easy path: 1. Buy a two pack mesh system. One unit replaces the Spectrum router and plugs into the Spectrum modem with the same cable the old router used. The second unit goes in the hallway or living room halfway between the modem and your bedroom. You only need power for the second unit. No coax. No Ethernet. 2. Set them up using the app that comes with the system. It takes five minutes. The mesh units talk to each other wirelessly and create one strong network. Your bedroom will get full signal because the second unit is right down the hall instead of across the whole house. 3. For brands, eero 6 or TP-Link Deco 6 are fine. They cost about 100 to 150 dollars for a two or three pack. Put it on your Christmas list. Either one will be miles better than what Spectrum gave you. 4. Do not overthink MoCA or powerline. They work in some houses and fail in others. Mesh is the least headache and works in almost every small house. If you do those steps your PS5 will stay online and you can stop fighting with the signal.
I replaced an older Netgear Orbi system a few years ago with a TP-Link Deco to get WiFi 6 and outdoor APs. It worked great for a few years and then because extremely unreliable. We switched about 6 months ago to a Firewalla AP7 WiFi system powered by a Firewalla Gold SE. I absolutely love the performance and reliability but it was the robust security is what drove the decision. Ubiquity was the other option we considered. They’re very compelling but we already had the Firewalla Gold SE router.
I have a basement, first, second and third floors. ISP's router on the first floor (WiFi 7), and a TP-Link Deco on the third floor (WiFi 6) that's wired to the router on the first floor. Coverage is fine, 500+ mbit everywhere. I dislike the Deco's forced online login and management via a phone app only, and its lack of logging or other functions, so I recommend against it, but otherwise the performance is more than acceptable. And the ISP router is pretty damned good (Orange Funbox 10).

eero
Pro 6 Series
Easy, reliable, smart home ready; but paid features.

TP-Link
Deco XE75 Pro
Great coverage, easy; but unreliable Ethernet, poor app.

eero
eero Max 7
Incredibly fast, reliable; but very expensive, limited control.

eero
eero Pro 7
Fast, reliable; but paid features, needs internet to function.

eero
eero 7
Easy, reliable coverage; but no 6GHz, paid features.