Never really cared for that show. But I think DS9 and VOY mostly appealed to different parts of the TNG audience. I got my DS9 and was happy, and if people were happy with VOY, why not?
So yeah, I HATED all the characters, I hated the villains, I hated the "action for the sake of action", I hated the Talaxians and the foreheads of the week, but it always felt that it was a finished product. I thought the next Trek might be more for me again.
But when ENT came along and had the same problems and worse, I was annoyed.
What most Niners would disagree with however, is that I think they handled the Borg rather well.