It was cool when they were a distant race far removed from humanity. Once they revealed they have been around for thousands of years and have been all over the galaxy, it made no sense. In all that time, the Borg have never before encountered energy weapons that fired at a particular frequency? In all that time, they’ve never encountered ballistic weapons?

I can buy they are trying to be super-efficient and don’t bother with defenses normally, but even when they are actively attacking the Federation, they seem not to bother until they are attacked.

As for the rest, the Borg have indeed been written very inconsistent since their creation.Now I don't mind that the writers added that the Borg also assimilate the members of a civilization that the Borg have targeted, to me it makes them more awesome and scarier, but a lot of the changes that have been done to them during and after First Contact only worked to the detriment of the concept.

I also think there should never have been a queen and I think it was only introduced because the writers probably thought that movie audience which probably would include people who did not watch TNG on a regular basis or only sporadically would need to see a "villain" the Borg because the idea of an enemy without a central leadership would be to strange or hard to imagine for them.

And it is indeed weird that every time that Starfleet encountered the Borg that their phasers are still effective at the start.I assume that a lot of species that uses direct energy weapons may perhaps use them at frequencies or configurations that are unique but at some point there would be some overlay (not sure if that is the right word), rendering weapons of other civilizations useless the first time they use it.

And yeah, it is a bit far fetched that the Borg never encountered ballistic weapons that were used against them.

I still like them though but they are no longer the powerful and mysterious enemy that they once were in "Q Who" and "The Best of Both Worlds",

Pretty sure that they will be the next iconic Star Trek species re imagined by new writers. (Mike Johnson already did so in Boldly Going and it was clear that he did not understand the Borg or barely watched any episode with them. Borg ignoring ships that attack them or just threaten their crews before going away, Borg drones referring to themselves as individuals and using speech to exchange information, the Borg never adapting to the weapons of their enemies, the Borg apparently assimilating for the sake of assimilation and no longer for technology, oh and human/Vulcan hybrids are now harder to assimilate forcing the Borg to play mind games)