I thought they looked pretty good in standard definition at the time. If not for the Amiga/Video Toaster platform used for the FX, the show might have been too expensive to make.
TNG never had battle scenes on the scale B5 had, and DS9 didn't attempt it until they had CGI.