What I'd prefer is the ability to modify/add CSS styles from within the CMS.
This could, for example, allow users to modify css and preview the result on an existing page before applying, or add new styles as they need them, rather than manually editing stylesheets or providing ad hoc style generation within the content editor.
Yes, it's more work, but I think it maintains styling without sacrificing flexibility.