There's also simultaneous appreciation and aversion.
There's some experimental and challenging modern classical compositions that I can appreciate aesthetically but which are, at the same time, almost painfully unlistenable. Steve Reich's Four Organs is a good example [1]. It's music, I hear the structure of the music, my mood shifts with the music, yet after a few minutes... aaaaaaaaaaghh! turn it off!!!
In the dramatic arts, there's the whole genre of horror.
I'm fairly sure this extends to foods. Some people like to eat foods that are right on that threshold between triggering intolerable revulsion and excitement.