I believe it can only help google to crawl your site better (or not). So even if it does work for only 25 % of your site (as example) it still would be a litle beter than noting richt?
I was just wondering what happens if you don't have sitemap plugins for all your modules. The generated Google Sitemap will not be complete, isn't this making things worse?