Elected in the 1997 landslide, Westminster’s answer to Hugh Grant was one of the first openly gay MPs – and a firebrand on TV. After 27 years, he reveals why he’s leaving politics behind