I don't see a general apathy towards Psycho compared to The Sixth Sense. That implies that everyone might prefer the latter film or be somehow dismissive of the former. Instead, I think there was much more contention about The Sixth Sense whereas most people generally agree about the place and praise for Psycho. Also, it's a much more thoroughly examined film, with countless opinions already given and gone over countless times. Heck, Psycho's has had literal do-overs of the entire film, where The Sixth Sense is reduced to a catchphrase.
On my personal Letterboxd ranking, I went ahead and put Psycho above Citizen Kane. I wondered if a film would ever do that, and the way I'm making the Letterboxd list is one that relies on gut feeling right after I watched the film but before I listen to the podcast. Does it belong in the top half? Yep. In the top fourth? Yep. Above All About Eve? I guess so. And Citizen Kane? Wow. Actually, yeah. Who knew?
But then Raiders came along and I have to put it on the top. I'm sure I'll have much to say about that one when the time comes.
Edited to add: https://letterboxd.com/dannythewall/list/unspooled-afis-100/in case you'd like to look at my fevered mind