The hotly tipped comic was the talk of Edinburgh with his blistering hour of hilariously hollow egomania – and audiences haven’t a clue whether to pity or deplore him