Regarding Wi-Fi 7: Take some time to read community forums for the companies who make Wi-Fi 7 access points. It's pretty sad.
You will find a lot of posts from early Wi-Fi 7 AP adopters who wish they could return theirs. The first crop of Wi-Fi 7 APs have painful issues involving backward compatibility with 2.4 GHz IoT devices. With Wi-Fi 7, beacons have changed, WPA3 is required, and WPF gets enabled. All of that creates compat issues with certain older Wi-Fi devices.
The AP makers have been working to solve those when they can with AP firmware fixes, but now it looks like some are pivoting to rev their first Wi-Fi 7 AP HW designs to move on from the first-gen SoC parts they used to build their APs.
I'll bet $1 that Wi-Fi 7 2.4 GHz IoT back-compat won't get fully resolved until next year. I'll bet another $1 it'll take Wi-Fi 7 AP firmware and client driver developers until late 2025 or 1H 2026 to get MLO rock solid. I could be wrong, which would make me really happy.