Wi-Fi keeps dropping out on my MacBook Pro running Sequoia

Radio Signals from your router fall off as the cube of the distance if you have clear line of sight and no competition from neighbors' Routers or known interference producers like microwave ovens.

All other need to do a more careful analysis to find out what is happening.

Wireless diagnostics:

Hold down the Option key while you click on the Wi-Fi icon on the menubar to open up the tools for investigating and fixing Wi-Fi issues

First is "Open Wireless diagnostics", which opens the wireless diagnostics Assistant, but does not proceed.

There are about eight different things you can do from here, but the top-level is to choose Diagnostics off the Window menu, or simply click continue, to do a quick check for Gross misconfiguration or operating problems. Your Admin password will be required. If any recommendations are shown, you should consider then seriously.

Next is to hold down the Option key and click the Wi-Fi icon as before. The screen that opens shows operating parameters of your network. Screenshot, transcribe, or photograph the results and post back in a reply on the forums. Looks like this older one.

when troubleshooting Wi-Fi issues, I recommend first ruling out problems with the radio transmission of the data before digging in to more obscure issues. What is your signal strength (RSSI) and other operating parameters?

Are you using any USB-cabled peripherals?

Have exactly the same issue only happens in our household on both macs running sequoia?

all other devices iPhones, windows pc, tablets all have no issues at all…

from my perspective it feels like a dns issue which is isolated to sequoia?

yes this is also happening to me where wifi gets randomly dropped, for reference I have new macbook pro m4 pro updated to latest Sequoia OS 15.3.2.

But on my old macbook air m1 Sequoia OS 15.3.2. this issue has never occurred before.

Im assuming its related to wifi 6E on the new m4 pro model?

[in my opinion] the changes for Wi-Fi 6 which were implemented quite some time ago, and have been benign, and not likely to the the cause of theses issues.

'assuming' will not get you any closer to a fix. Instrumenting and looking at the measurements available is more likely to provide some clues, which could lead to a fix.