I think the biggest draw back in using auto-assign is that the computer assigns titles to the best general in that turn. If a better general spawns later on you have to reassign manually. I hate this as I want my govenors with highest acumen possible adminstering my best economic provinces.