By series:

• TOS: Uhura - loved her skin and beautiful voice!
• TAS: It’s a cartoon, so no.
• TNG: Troi, especially in the purple and maroon jumpsuits
• DS9: Leeta - street smart and sexy as hell
• VOY: 7 of 9 - again with the jumpsuit (seeing a theme yet?)
• ENT: Hoshi, doubly so in the alternate universe
• DSC: Detmer. The hair and heterochromia are sexy.
• STP: Seven again. She’s aged so beautifully.
• SNW: Chappel - action packed beauty

I look at it as a future that could’ve existed, but because of the way the episode played out it never came to pass.

As far as the future uniforms matching, to me it just means that uniform design wasn’t intricately tied to Picard or the Enterprise - it was just the flow that uniform was going to take on its own. However, had anyone involved in uniform design been impacted in their uniform design capacity it could’ve been different - it just wasn’t.