Exhibition at the Gemäldegalerie explores myths around the artist's mental state popularised by a later painting, as well as his position in Western art history