Other than maybe some Disney songs, when it comes to an obscure one hit wonder band to have a song featured in a movie that became widely known and popular, I doubt there are much more bigger than Scotty Doesn't Know by Lustra.
Not to mention, Matt Damon having one of the best and most random cameos ever made. To me, Eurotrip was one of the last great old school teen movies in a genre that lasted nearly 20 years...along with Mean Girls that came out 2 months later.
Edit- Shoutout to u/Competitive-Boat4592 "America, Fuck Yeah" may be the number 1 song to meet the criteria.