It wasn't alien tech. But it was presented as something special. What I'm referring to is Geordi's visor, in TNG.
The visor obviously gave Geordi sight, of a sort. And just as importantly, it gave Geordi capabilities that other humans didn't naturally possess.
There were a number of episodes, early in the series, where the plot highlighted the visor's capabilities, like in "Heart of Glory", where we saw the visor function in all its glory.
In "Too Short a Season", Geordi's use of the visor helped the landing party navigate Karnak's tunnels. And in "Up the Long Ladder", the visor allowed Geordi to function as a human lie detector. That's not a bad ability to have.
To the writers' credit, it wasn't overused. I don't recall too many episodes where Geordi used his visor to save the day.
In fact, there were other stories where the visor was shown to have vulnerabilities that were exploited by the bad guys.
But here's my issue with the visor. Starfleet engineers are smart. So why didn't they manufacture a visor that had the capabilities of Geordi's visor, but that could be used by someone with normal sight, something akin to present day night vision goggles.
I'm not saying that someone should wear such such a visor all the time. If a mission requires a certain capability to be employed, then the crewman would simply put on the visor for the mission.
But, of course, Geordi would have lost his specialness if that had happened.
Geordi was a relatively boring character imho. The visor, at least, gave the character his claim to fame.