The artist’s exhibition is at its best in its quieter, less spectacular moments