On MacOS that would be an amazing poor UX, cmd+tab works on Applications, not specific windows.
Switching windows within the same Application is cmd+` ; and only works on the current workspace.
I agree it would be a poor experience, but macOS does have an additional shortcut key for switching between windows: Command–Grave accent (`)
What about using AltTab?
https://github.com/lwouis/alt-tab-macos