One of my personal favorites was Relics from the 6th season.

Montgomery Scott and Jordi working to get an old ship running so they could find and save the Enterprise was just classic Star Trek storyline.

Let's not forget "A Fistful of Data's or the one with the little binary beings that used the memory storage of the Enterprise to hold their societal data for a reboot.

Chas