Apparently by the end of TNG’s run the writers were really struggling since having no interpersonal conflicts (a key tenant laid down by Roddenberry) is pretty bad for character development

DS9 did good in adding a bunch of non star fleet characters who had maybe more realistic motivations. Voyager tried but immediately just turned them all into a big happy family just like TNG.