I'd like to turn off Content Approval, for all libraries, (Page, Document, Images) once, at a Site Collection level and, hopefully, it will be automatically set across the entire site collection. Having it off helps during the development of a Publishing Site. Once all the content/web parts are in then it would be good to turn it back on before going to UAT/Prod. Having approval workflows start in dev is just a waste of time.
I'm working in SP2010, but MOSS 2007 is still relevant as I have sites in both platforms.