It really depends on the parish.
I was raised in a more traditional Presbyterian church and while we had a small congregation we had a decent choir and sang traditional hymns with 4 part harmonies. I spent 3 years in the choir while in high school. There was a certain gravity and solemness to worship there. I guess that’s not surprising since it was definitely a Calvinist church
When I came to the Catholic church I expected the gravity and solemnity to be even more apparent. In my mind I thought if the church I grew up in was like wearing a warm jacket, then the Catholic Church would be like doing a heavy velvet cloak. Something that had weight and a deep texture that perhaps the Presbyterian church was missing. One of the first parishes I attended was more like putting on a wind breaker or something made from a lightweight fabric. All the traditional elements (i.e. incense, organ, chant, etc.) had been thrown out the door and literally replaced by a folk band where the earliest piece was from the mid 70’s. The priest’s chasuble even looked like it was tie-dyed with various shades of green. I had to check twice that it was a Catholic church since it didn’t seem like what I had expected in my mind.
So long and short? Each parish is different. Some hold traditional worship as much more important than others. It is one of the beauties of the Catholic Church; when I feel the charismatic rock Mass offered at my local parish will be a distraction I can always go to a High Mass or
missa cantata at a nearby FSSP parish.
While I might have a preference for how the mass is celebrated even the silliest mass still has Christ present. I often amuse myself thinking of Christ in the tabernacle shaking his head thinking “these people are nuts, but at least they came to be with me.” Then I offer up my suffering as the latest Marty Haugen song assaults my ears.