Same here. On the other hand I think it is just how some people are. I do not appreciate art, and can live happily without music. Art in general, never gives me any profound experiences. Books on the other hand, now we're talking! Political performance art, also entertaining.
Idk if you ever shared this view with art people. It must have been hard because there is a sort of obligatory necessity that people MUST like art embedded into their worldview.
But also, there is a basic universality of art, and I wonder where it comes from, and what would make some people into it, and others, like you, not into it.
For some, it’s the sheer grandeur and architectural splendor. Strasbourg, Chartres, Cologne or Rouen Cathedrals, with their scale and delicate designs, often stand out.
For others, it’s the spiritual resonance of a place. The Cathedral of Santiago de Compostela has stirred something deeper within, but maybe that was just me. I experienced the same with Lourdes and Le Puy-en-Velay in France because they carried something that felt "sacred" and transformative, not only from the buildings but the actual place.
Then there are those who value historical or religious authority. Cathedrals like St. Peter’s in Rome or the Papal Palace in Avignon have that kind of symbolic weight, and I assume some would favor them over the more "profane" work of Gaudi.
As I wrote in another comment, I think the Sagrada Familia is a worthy successor for the grand gothic cathedrals you mentioned, because Gaudí made the most out of late 19th century technology, same as the medieval builders made the most out of the technology available at their time. I mean, just look at those branching columns: https://de.wikipedia.org/wiki/Sagrada_Fam%C3%ADlia#/media/Da... But, to each his own.
I would like to add two (former) churches to your list: the Hagia Sophia (it's really humbling to think that it was already standing for 900+ years when the Turks conquered Constantinople 500+ years ago) and the Pantheon in Rome, which despite being several centuries older, had the largest dome in the world for more than 1000 years.
St Peter's Basilica is probably the most mind-blowing for me, even just because of the scale. The intricate facade of the Duomo in Milano, the green and while marble exteriors of the Duomo in Firenze, the (neoclassical?) architecture of St Paul's, the unusualness of St Francis of Assisi, Notre Dame (haven't gone back after the fire yet), the bright golden interiors of pretty much any Orthodox church,... Hagia Sophia if I may stretch the definitions a bit :)
.jpeg){kind=link}