He was so great/lovable they ended up making him a quasi good guy (like yu or mayborne).
SG1 is one of the (if not THE) best bad TV shows of all time.
The gouauld are an alegory for the "owners"/slaver class.
RIP indeed, and my (our, the people who appreciated him) sincerest condolences to his family.