In retrospect it was great and is set before DS9.
Like most series its first season it takes time to get its footing, but then it introduces the Borg and goes from there.