I am also a visual person with photography interest. I particularly like when the cover and the music have relationship. Some examples:
The Ex - Blueprints for a Blackout
Sonic Youth - Daydream Nation
Yakima Jera - Capture
Videotraum - Ebbe // Flut
I don't buy albums just for the cover art, but certain cover art has made me pause with the purchase. E.g., She pleasures herself - Latex, but I very much like the music.
And then there are the creative cover arts such as the variable inserts into the die-cut cover of Throwing Snow's - Dragons. Or the Art edition of Volcan's - Chansons pour le néant. Or the friendship editions from eins.zwei.acht label. That is I find truly exciting.