This is exactly what I do -- but I have space split up by persona (Personal, work 1, work 2, Play), and then each space is managed with Moom. Love it.
Finder, chromes, etc. it will cause automatic switching.
Also, cmd-tab doesn’t have a filtered mode for the active space
Cmd-~ actually works better when using stage manager, because it goed through all active windows across all apps
1. When switch into an application switch to a space with open Windows for the application.
2. Automatically rearrange space is based on most recent use.
Nothing provides structure, and separation
Ideally I’d just run 6 users in 6 spaces
The whole cmdtab shouldn’t show applications without windows nor als with no window in the current space