I am using an M2 Mac Mini Pro with Sonoma 14.4. I have two separate Wi-Fi SSID associated with different subnets — one for Wi-FI 802.11n devices, and the primary configured for 802.11n/ac/ax. The router is a Synology RT6600ax with current firmware. The primary SSID connects and stays connected from the time I power up the mini until I shut it down. No Wi-Fi loss at all as long as there is no power outage or ISP delivery issues.
I also happen to have a Netgear Nighthawk M6 Pro WiFi 6E hotspot router on a carrier data plan which provides a separate 6E SSID (and another subnet) to the mini when used and I choose that SSID. When I shut it off, Wi-Fi automatically falls back to the primary 802.11ax SSID that I ordinarily use all day.
There is nothing for Apple to resolve in my setup, and although there are several posts (and my own experience) about intermittent Wi-Fi connectivity rate fluctuations to a router, I have not read any posts where the Wi-Fi connection chronically drops entirely. That sounds more like a router or ISP configuration issue.