This plugin: http://firestats.cc/wiki/WPMUPluginCommander
bypasses the network activation stuff and does its own. and lets you disable the plugin on a site by site basis.
Update: Looks like this plugin breaks the sitewide tags plugin, so be careful before trying on a production network.
