Stargate SG-1 and Arlantis. They often felt more like a modern Star Trek than the Trek spin-offs. They had the sense of fun and adventure which vanished in the overly-serious TNG and we saw only a few snippets of in Voyager.
Trek-wise, Voyager and Enterprise are my next favourites, Trek-wise. ENT's third season was fantastic.