Could the Q be merely humanoids with advanced technology?

[Kythnos]

My point was there are Trek aliens who also have near god-like powers. The Q could just as easily fit that department. Further, as evidenced by Amanda Rogers being born a Q, if there is a "technology" behind it then access to it may be on some biological level.

And I don't disagree with you completely me may well be what he says he is, or your comment about Tech on a biological level could be dead on. (a little more on that later)

I honestly have not watched it since it first aired, nor am I terribly inclined to re-visit it unless armed with vodka.

I know what you are saying here. Just thinking about that,... well I am not sure what to call it, that massive steaming pile of shit, makes me feel dirty. (side rant here: I do find it truly remarkable that Voyager can make everything it touched SUCK so bad. The Borg and the Q it seemed that nothing was beyond it's ability to putrefy?)

Could the Voyager crew have been "bestowed" with Q-like powers, like Riker in TNG for that battle?

We never see them do anything other than fire the guns and threaten the other Q with them, but even if they did the "guns and cannon" would still be able to hurt them.

Just a few comments/questions about this:

If there is a technology behind the Q, it is something that nobody in Star Trek has come close to identifying as such. Q has hurled starships through vast distances and through time,

Well we have seen ST travel in time very easily, so easy that in First Contact Picard just tell them to set course for home.
In an Episode with Barkley, "Infinite potential" maybe?, he uses knowledge gained from a alien probe to move the enterprise a vast distance without warp drive. In fact Q's son does something very similar in Voyager.

changed the orbits of Moons

A feat that the Enterprise was accomplishing without him.

given a man either a near-death experience or an actual chance to relive his youth...

The Episode "Inner Light", if memory severs, Picard relives someone else life, but as he would have lived it.
Even Picard comments on Q's "impressive parlor tricks".

Or creatures that have evolved way beyond us, of which there are several examples of in Star Trek.

Honestly up to THAT episode I would have questioned how anyone could disagreed with you but now I have my doubts. Not saying you are wrong just that I am not so sure anymore.

[Metahive]

Why, exactly, would she have to carry all that technology around with her? All she needs is access to the technology and the ability to activate it. The technology itself could be parked anywhere. Subspace, the Q Continuum...
All Amanda Rogers shows is that whatever grants one access to Q powers (whichever way they work) is apparently inheritable.

And somehow everyone overlooks the noticable energy spikes that should occur every time a Q uses his powers if it were this way? Doesn't hold up.