This is what I don't understand. Ok apple does not care or does not want to spend resources on the window management mess of MacOS for whatever reason (iOS is more important, MacOS does not bring services revenue etc)
Just open the API for the 3rd party developers to fix your mess!
Coincidentally, after 10 years, and 100 releases of 0.9, HammerSpoon just released 1.0 in August 2024:
Hammerspoon is a bridge between the operating system and a Lua scripting engine. What gives Hammerspoon its power is a set of extensions that expose specific pieces of system functionality, to the user.
You can write Lua code that interacts with macOS APIs for applications, windows, mouse pointers, filesystem objects, audio devices, batteries, screens, low-level keyboard/mouse events, clipboards, location services, wifi, and more.
Just open the API for the 3rd party developers to fix your mess!