how to bulk edit node categories and terms, and manage a large Drupal site

I've been using Drupal for some time now in many sites, and still certain basic things cannot be done that I would like to do. At least - things that seem basic to me - that I don't think Drupal currently does.

I have 10,000 nodes - mostly 'stories'. Some are categorized - many are not. I want to be able to categorize nodes 'in bulk' and assign them terms, etc. Give me a form where I can either check off nodes on (without editing each one) to bulk change or add to category or vocab terms. Optimally - being able to search for keywords, and assign everything that comes up to a vocab or taxonomy term would be great. Is there any module or anything that comes remotely close to doing this?

I use pathauto to generate paths for nodes, but it doesn't auto-assign to vocab terms, and it doesn't auto-create them (from the title). Is there a module out there (besides auto-taxonomy with aggregator2, which is a broken piece of garbage)?

I want a better page or tools to "manage my site". i.e., a dashboard with things like "you have 10,000 nodes. x amount are stories, x amount are images, x amount are book pages..." and then be able to drill down into them. Click on stories, and I should be able to slice and dice them by taxonomy, and then bulk edit, or whatever I need to do.

I have a module installed now that gives brief synopsis under log statistics, but not much. I have control panel installed, which only puts a pretty fact on features already available in Drupal. I installed Administration, but it hangs Drupal every time I install it.

Help with any of these is appreciated!