My only recollection was that I found the ending shocking and unexpected.
Learning about it afterwards, I see how there were interesting aspects of "Psycho", particularly for its time, that went over my head when I was young: that the "protagonist" at the start of the film stole money and so should not have been sympathetic, that they switched protagonists half-way through.... It was a departure for sure for Hollywood.
I have been working through the "1001 Films to See Before You Die" for a few years now and so have come upon films like "Texas Chainsaw Massacre" at an age now where I seem to have lost my patience for depictions of cruelty.
I liked "A Clockwork Orange" when I was younger, like it less now.
Another example, I had heard about "Pink Flamingos" from its reputation but only saw it recently due to its being on "1001 Films". Hard pass on that film too (although I like some of John Waters later films).