I have the same problem, and "Auto-Join" is not a solution.
I would like my MacBook to auto-join all networks at home, but I need to be able to set a service order - the thing that was possible to do in previous macOS versions.
When the preferred network is not available, it should switch to the other one.
Wireless Diagnostics even wants me to do that:
Preferred Network Mismatch
Your current Wi-Fi network is remembered in your preferred networks list, but has conflicting information. This may prevent your Mac from automatically rejoining this previously joined Wi-Fi network.
Remove the problematic network from your preferred networks list.
Steps
1. Choose menu > System Settings, then click Network.
2. Select Wi-Fi from the list of network services, and then click Advanced.
3. Select your current Wi-Fi network name from the Preferred Networks list and click the “-” button to remove it.
4. Click OK.
5. Click Apply.
But that seems to have been removed in Ventura.
How can I achieve what Apple's Wireless Diagnostics is telling me to do?