Of the many albums that succeed in that department, I've still got Rodrigo y Gabriela's 11:11 on top of my list. The album starts by hitting you over the head with a brick (Hanuman) and moves through every song to an ending so unearthly that when it has faded away you wonder what happened and where you are... it releases me from a dream every time.
But back on topic, anyone know what Paul Simon's doing now? Maybe it's time for a google search.