So what you see in movies, specifically comedic presentations such as you mentioned, is played for comedic effect. That being said, there is some wild shit that goes down in Pentecostal/charismatic churches. (Charismatic describes practices which include “speaking in tongues,” people “falling out” or being “slain in the spirit,” dancing, running, shouting, and other ecstatic expressions)

When I was a kid in the 90s we had “revivals” that would last 3-5 days. Sunday morning, Sunday evening, and Wednesday evening were already church days/nights. Revival made Monday, Tuesday, and sometimes Thursday and Friday church nights too. The longest I’ve personally experienced was 2.5 months, I know of one church that went for like 3+ years. In both of those longest cases, there were some significantly fishy things happening they just kept having services regardless of anything driving it. There would be some retired folks or stay at home moms that would come in to pray during the day on occasion but it was mostly just church at night. Historically, this is how tent revivals ran too. The air was cooler, people were done working, cleaned up and went to hear the preacher who traveled the country. This is what they were talking about in Steel Magnolias. It’s not as common now, but it still happens in older more traditional Pentecostal churches.

Now, as to how common it is and where you’ll find it, there are some rules of thumb. If you’re going to a predominantly white church, there are a few denominations that trend toward charismatic practices: the church of god, church of god of prophecy, assemblies of god, and some seventh day adventists are the major pentecostal denominations. You’ll also find plenty of nondenominational churches that are pentecostal/charismatic and they’re mostly clones of the major denominations but split off into an independent church; same theology, different organization. Outside of these parameters, white people don’t tend to get very charismatic in church. When it comes to predominantly Black churches, it’s a little more common to see charismatic practices across denominations and may or may not be rooted in Pentecostal practices and theologies. A white Methodist church is unlikely to be charismatic while an African Methodist Episcopal (A.M.E.) church is more theologically aligned with the Methodists than their evangelical counterparts, you’re more likely to see charismatic practices at an AME. Other race-dominated congregations tend to be similar to white folks (but this isn’t a hard and fast rule). I have my opinions on why this is…but this comment is long enough already.

I can regale you with plenty more first-hand experiences, history, theology, and stories if you’re interested lol. I have a degree in ministry from a Pentecostal university, worked as a children’s pastor, and have become an empirical atheist later in life.