The regular OSX workflow seems to be only good for a workflow that includes a single maximised Chrome window with a million tabs open.
It’s absolutely wonderful as a window switcher for macOS, second to none in my view.
My windows currently open: ~50 iTerm2 (with loads of tabs and tmux sessions), 5 TextMate (quite a lot of tabs as well), 6 Safari (ditto), 1 Messages, 1 Mail, 1 Music. Cycling through the 50-odd windows to swap to mail would be insane.
The use case you mention is precisely where application orientation is useless, I am not sure why you bring that up.
In most cases I have several windows open but I want to cycle between 2 or 3. I find Windows-like window switching much better, but I guess your mileage may vary.
Switching between 2 windows works fin with command-tab, because it brings only the window that was in the foreground, not all the application's window. So, for example, when switching repeatedly between the same windows in TextMate and iTerm, a single command-tab always brings the other window to the front. Another of my common use cases is looking for papers in Safari, reading them in a bibliography manager, and writing manuscripts in a TeX editor. Again, everything is as smooth as it could be.
It is actually a bit more cumbersome when you have to switch e.g. between 2 windows in one application and a window in another one. Overall, these drawbacks make much more sense to me than Windows' alt-tab's, and the system fits my workflows much better.
You can also switch between applications by using tab whilst in this mode (though it is not too convenient because there is little feedback about which application os selected).