If you find Akira Kurosawa's Dreams (1990) at the rental store give it a try. I watched it several years ago and remember the evocative power of these 'dreams'. The film consists of eight different segments, each one a dream; Kurosawa's own dreams. Whether dreams he dreamed in his sleep or dreamed while awake we don't know.
The following one, 'Crows', is probably the film's weakest segment (the part where the aspiring painter walks through the painting stills looking for Van Gogh is cringe worthy, and are those commercially pre-stretched canvases that Van Gogh is carrying?), but interesting nonetheless. George Lucas's Industrial Light and Magic provided the visual effects.
And Scorcese as Vincent Van Gogh...bleh. Bleh. Bleh. No thanks.