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.

You will still run into shit when one application instance is used in two spaces

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

In system settings for desktop and dock you may want to experiment with:

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.

Tried everything

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