The presenter was once synonymous with nineties hedonism; her tumultuous life a source of public fascination. She may now be done with fame