I think I related more with the character on DS9 & Voy better too.
I've always thought in the back of my mind If the characters in TNG were real, they probably wouldn't be interested in talking to any of us but the ones from Voyager would.
Yeah, this. TNG characters never engaged me. Picard is a fine captain but I don't actually give a fig about him. And the rest of them vary from seemingly no personality (Geordi, Crusher) to annoying or vile (Troi, Riker).
They're just not my people.