I hadn't been to a CS event before IEM Dallas, and I gotta say, being part of the crowd was incredibly fun. Never been to a valorant LAN so I don't know how it compares, but this one set the bar pretty high.
I don't think we'll ever see stuff like that in Valorant, partly because of the community. However, Riot also tend to play very advertiser safe, and most American advertisers are the most puritan mfs you'll ever meet. No swearing, nothing remotely controversial or disrespectful. Tl;Dr, I think Riot wouldn't even allow or cater to this type of crowd even if Val community was like this.