I know nothing about classical or opera music, however I do enjoy listening to some of it. I do recognize some of the melodies but don't ask me to name it or who wrote it chances are I won't know. I am Limited in pieces I can identify.
There is one piece of Opera the melody haunts me, I've heard it sung by many artists.
For me and others the best was Luciano Pavarotti's performance of "Nessun Dorma". You can find this amazing performance on YouTube, and by the glow on Pavarotti's face at the end, he thought it was an exceptional performance that night.
It was 1958 or 59 I was 15 or 16 years old I purchased a record album called "Storm In Hi Fi". It was a classical compilation of music as a thematic subject. One of my favorite track was Rossini's William tell overture. In the beginning you could hear a Ping, then another and then a few more, this represented the raindrops, then you hear swirling wind and it develops to a full-blown storm and then settles down again. Some of the other tracks on the album were Beethoven's Symphony Number 6 Tempest and Storm, Sibelius The Storm, Hugo Alfven summer rain. I listen to that record often.
I have also purchased record albums, and CD' with a different take on classical music. One was David Rose swings classical music. He arranged these classical pieces to work with a swing band. I also had an album where they took Beatles music and arranged it in a classical fashion.
It was all enjoyable I guess that's my experience with classical and Opera music.