I've just put some D'Addario flatwounds on my SG and they're superb! I went for 10s, as I was already set up for this gauge, and am very happy. They're really high tension (compared to my usual D'Addario XL10s), but the sound is superb.
I tend to just play Jazz, and riff based prog rock (think TOOL etc…), so the issue about bending high tension strings isn't really an issue for me.