The idea is that you post a question, attempt to answer it, and then let us discuss as well.
But yeah, I would say for some cd's it's an art, for some it's a last minute scramble.
I can't specifically think of an album where I was just blown away by what songs came in what order, often there are two sides to the cd, the best song is 2-3 and the other best song is 12-14, etc shit like that.
I don't usually think about it, I often put in a cd and hit play (or select from a list). I usually know what song is coming next and if my music is on random or something it throws me and sometimes annoys me.
Also, some banRAB put purposeful transitions, which can be more annoying than not.