Yes it looks good but in practice, it doesn't really add any ease of use. Much quicker to scroll down a grid display of album art.

Cover flow = Pretty but slow navigation through a large library.