I'd say that these were albums "I thought would be good" instead of "wanted to love".
Already mentioned and in agreement:
CYHSY had only a few likeable qualites
OK Computer is well done but Radiohead are not my bag.
Not mentioned:
The last Mars Volta album
The Bends
Horses - Patty Smith
Broken Social Scene
Jody Foster's Army - We Know You Suck
The White Stripes - The White Stripes
Big Black - Atomizer
The Stone Roses
These just come to mind without much effort; I'm sure there are plenty more.