I wouldn't write off the cancer risk so easily. Sure the rat studies used high doses, but that is pretty typical protocol for drug testing. Rats have short lives and cancer isn't going to show up fast enough unless high doses are used. But the evidence is usually considered translatable.
It sounds like the evidence is pretty strong, and the drug, despite its possible HDL benefits, will never be approved, because of "serious toxicities" and "tests on rats showed that at all doses, the drug rapidly causes cancers in a multitude of organs, including the liver, bladder, stomach, skin, thyroid, tongue, testes, ovaries and womb".
Take that for what its worth. Maybe it causes cancer like saccharin causes cancer (?), or maybe its much worse. I'm just saying you can't come to any conclusion about it being safe by looking at the studies and assuming that the study conditions don't apply to you.