Despite the predictably & performatively negative reaction the Japanese artist inspires in some critical quarters, it is clear she has been responsible for a cavalcade of bangers over the decades. With a new retrospective at the Tate Modern, Jeremy Allen explores her back catalogue