I too get often a headache from red wine (even from a small amount),
but only if it is too young or otherwise poor quality.
The hideously expensive ones are usually all right with me.
Luckily I can tell which ones without tasting, the substance that
causes trouble gives the wine a blueish hue at the rim.
My first and only experience with Bacardi & Cola was something
I have been trying to forget for 20 years... At the end of 9th grade
our whole class went to Crete for a week to celebrate (we had decided to
go at the beginning of 7th grade, so we had three years to work and save)
On the first night we sneaked out of bed and had a party! I got sick and
the bathroom was already occupied, so I staggered into the balcony.
Next morning our teacher gathered up us all, and demanded to know, who had
vomited onto the hotel's owner's motorbike

No more Bacardi for me, ever!
Nowadays I drink alcohol rarely, but my favorite is to pour a dash of something
good into my coffee, and top with whipped cream.