DS9 Had several episodes that explicitly follow the civilian lifestyle of Sikso's father. The major plot point is about the strife between ordinary citizens being subjected to security tests who are not part of Starfleet.

There was one or two like that in TNG, but those were very conspicuous in their intent to depict a day in the life of the crew.

And they were still about the crew, not about civilians.