Hiya
To answer what I can answer, in order - others will have more detailed information:
Making the Storyteller a settler: I doubt that this will be integrated into Sim Settlements or Conqueror, since there's no real need to. If there isn't a mod out there which already does it, how about writing your own?
Setting priority for beds: I believe that there is now an option in the holotape/MCM for all plots to be placed immediately upon a city plan upgrading. Both residential and work, of course.
DLC: If installed, Sim Settlements will take advantage of the DLC. For example: when Far Harbor is installed, agricultural plots will spawn radchickens.
Automatron settlers: I've had a few robots set to Industrial plots, though I've not tried with things like agricultural plots. Sadly the robots lack the animations for many things, so they might "do the work" while standing around as it were. By default, robots have a maximum 50% happiness - which makes city upgrades really, really hard.
Automatron leaders: Someone would have to make a special leader card for the robot - they have to be unique, not created from scratch in a robot workbench. This means that the only vanilla candidates are Ada and Jezebel. others would have to be added by a mod.
Bubble turrets: Some of the martial plots already spawn bubble turrets at high levels. This is so that they are not totally useless when an attack happens. If you want workshop-placeable bubble turrets out there, there are two mods that I know of:
Advanced Bubble Turret Set gives you bubble turrets that can be built on the ground, walls, and ceilings.
Whisper's Enhanced Turrets doesn't give turrets that can be build on walls/ceilings - you'll have to use Place Everywhere to spin them around. It does give "tiers" of turrets though, that are tougher/do more damage/give more defense.