While I was listening through the Dream Theater discography again, I was amazed at how they seemed to master how to end albums with a bang. Of course there are albums where my personal favorite is not at the tailend of the album (like for I&W), but I acknowledge DT's effort to close with an epic, or an epic + epilogue. So much so that if I am asked to choose either the first halves or the second halves of DT albums, I would definitely pick the second halves.
I guess it's also one reason why many were disappointed with TA. A lot of DT fans might have been conditioned to expect a strong second half or last third of the album as the sweet spot, which was not the case for TA.
Now I thought that this is a prog thing, but I was mistaken. Looking through the Yes and Rush albums, for example, their albums are largely frontloaded, with many of the fillers at the end of the albums. Other artists in other genres also frontload their albums. Metallica almost always starts their albums with the stronger songs. Another of my favorites, Savatage, also has the first part of albums as the sweet spot.
Personally, I prefer the sweet spot at the latter part. I am a full album listener, and I love ending my listening experience with a smile on my face. But I could also understand the logic of frontloading, because being forced to go though weak songs just to reach the sweet spot could make the listening experience a chore.