The thing is, this stinking union will not stop leaking at the
compression spot. I've cranked it down almost to the limits of what I'm
capable of doing. Is this right? Is it normal to crank the snot out of
these things, or do I have a faulty union or something?

Metal or PVC ? Is there a slot machined in there for an "O" ring ?