tongue in cheek counterpoint: Rimworld players love Random Randy :P
I think it really depends on the game though, but you're right 100% random in an RPG could be really annoying.
Right now I'm into games like Factorio and Captain of Industry and they've both recently had blog posts about how they do terrain generation and CoI stuck out because you can manually plop features like mountains and then it procedurally generates the mountain range[1].
There's been a lot of games recently that seem to be doing procedural land generation, is there not a way this can be applied to AI personalities as well or is there no overlap between them? It kind of feels like procedurally generated personalities should be do-able but it sounds like there's something more going on that complicates that?