That's something I always really liked about TOS/early TNG, maybe it's because I was also into stuff like 2001 and Solaris, so to me space should be weird and trippy.It shows the TOS spirit of exploration and the weirdness of space. Something that sadly wasn't nearly as present in TNG in the later seasons.
I do think a few of the early scripts Braga wrote for later TNG captured the same vibe, but I guess after a few years in the Berman machine it got beaten out of him, because I don't recall the same weirdness for any of his post-1994 scripts.
SNW is the only one of the newer shows that consistently has space weirdness (although DIS does have a couple).