A retrospective at Neues Museum Nürnberg assembles the artist’s gleeful critiques of social, political and economic conditions