Allows a user to modify front-end, (public) styles without modifying theme/plugin/core files.
Yes. You can put a different tweaks.css file in every themes root directory. Only the file that is in the directory of the current theme will be loaded.
I have only tested it with Theme Switcher Reloaded but it works fine with it.