I enjoy shitting on Voyager as much as anyone but it had plenty of good Borg episodes. The Scorpion two-parter and Dark Frontier are all entertaining watches, let alone all the ones that were more Borg adjacent, like Infinite Regress or Imperfection.
I'm not so much into Dark Frontier because I'm just not that into the Queen as an idea or character. The humanized avatar of an otherwise completely alien collective sort of made them a little too much like just another faction among others. Scorpion I forgot weirdly and it wasn't too bad. Also, the Unimatrix Zero two parter was quite good, but it was less straightforward Borg and more writing around the edges of what being Borg meant. These adjacent episodes were what Voyager did well with the Borg, because they didn't focus too much on trying to make the Borg as an alien intelligence comprehensible, but more worked on how humans tried to understand their experiences with the Borg. I guess Dark Frontier had some of that too, but I don't know, the Borg Queen kind of made it a little dull to me.
Oddly enough, I don't mind the Queen stuff in Picard as much, because they're just going full cheesy with it and she's become even more of a movie monster than anything resembling part of sophisticated alien intelligence. If they're not even going to try anymore with doing anything actually interesting with the Borg (the well's a little dry anyways) then I'm more fine when they just make them hammy monsters. Voyager straddled the line sometimes a little too much for my liking, or had a mix of the goofy stuff and the more thoughtful stuff.
It's an interesting aspect of Star Trek over the years - how different alien species are depicted and how some of them vacillate more than others between being totally cheesy and then more complex and thoughtful. On one hand you get the Borg and the Klingons who have been on both sides of that, and then you have species like the Cardassians and Bajorans who are pretty much only depicted with a more tempered, serious approach.
Death Wish is one of the best episodes of Voyager.
The one where the Q wants to die? I felt tt was really thoughtless and silly. I don't like it when writers try to humanize aliens too much by applying human existentialism or other distinctly human psychology. I don't think an attempt should even really be made to 'understand' the Q very much, because they work better as something otherwise unfathomable. When Picard recently said last episode that he 'used to think Q was unknowable', I thought this towed a similar line of thinking - that human understanding can surmount anything it comes across, or the indomitability of the humanistic spirit. To me, Q in TNG was an interesting character because there was always this abyss between him (it) and what a human was capable of connecting with. The episode 'Where Silence has Lease' portrayed this well, even though the entity in question wasn't Q. The entity, Nagilum, and Picard were only able to come to a vague connection, in that they each acknowledged the nature of intelligence to be curious. But the gulf between Nagilum and humanity was vast and it was better that this was left off as something to never be bridged. In similar regards, I think trying to apply human psychology to an immortal, omnipotent being doesn't even really make sense. Something to ask of a Q if its portrayed as suicidal is 'why?'. Why would it think that way? I don't think that question can sufficiently be answered because we as humans can not fathom what it means or is to be an infinite, omnipotent being that doesn't exist in time the way we experience it. Or like there's other questions there - why could the Q simply not snap their fingers and make themselves not feel suicidally bored anymore? What about their being would prevent that from happening? Why should the Q even have a sense of individuality as humans do? We only have that sense of ourselves because of our particular evolution, so to expect something that exists in a completely different and otherwise unknowable to be like us is a little wrong headed. If the Q don't even exist in linear time, then can they even stop existing? In "All Good Things...' Q enabling Picard to experience non linear time was like an extremely introductory measure sort of, like Q was ultimately communicating some part of its being by showing Picard what it would be like for a human to experience a consciousness unbound in time.
That episode didn't even try to think about all the questions that arise from considering what being a Q would actually mean. It was just 'Hey I bet an immortal being would get sick of it at some point and want to die right? Just like us humans'. It's a huge assumption about intelligence, that if not limited by mortality it would become bored. These assumptions can only come from our own parochial understandings of what it is to be intelligent and I don't think it should be projected too much onto depictions of something so alien in being, like an omnipotent, infinite intelligence.