I used to think like this, but no longer. Honestly, in an average album, there may only be 2-4 tracks that are excellent and the rest are just OK. This is a pretty common pattern and you can see reflected in the number of streams for each song. As for the album being the artists collective vision, I don't know that that is true. Maybe it is for something like Pink Floyd, but I get the impression most songs are written in isolation, rather than being a part of a collective vision.

In the end, why waste time listening to something you only half enjoy?