How do you mean? That sounds like basic TWM functionality. I know with something like Compiz when you switch to a workspace all of your monitors switch at the same time, which is kind of pointless.
i3 gives you 95% of what you could do yourself with Awesome, Xmonad et al, just without having to do much of anything beyond edit a config and choose which apps you'd like bound to which workspaces, which ones should go to the scratchpad (e.g. Skype, VLC, etc.), which ones should be floatable and so on.
The ability to tab tiles is probably the killer feature of i3, if you do sysadmin work being able to break a set of 20 terminals into a quadrant of 5 tabbed terminals each all on a single screen is pretty much a dream ;-) Furthermore you can tile vertically and horizontally within any given region, it's turtles all the way down...
As far as setup goes i3 is an absolute cake walk (relative to Awesome et al where you have to script your way to Nirvana), just edit provided config to your liking (yes, if you want conky piped into i3 status bar you have to do a little homework, but otherwise ridiculously straight forward).
If you prefer a full blown DE you can actually wrap a tiling WM over the DE (i.e. they can work together) so the answer to the OP is an emphatic yes, any Linux can do the trick.