I have to disagree with you, I think they can still look good if done well, but in another way I agree with you, people who use them badly have overused them(I'm probably guilty of this) but I still think they look good: (00:16)
Just google "Film Burn Pack" or something and I'm sure you'll get a pack in which you can download. But like others said in this thread, they are over-used, so use them wisely.
As much as I enjoy that edit, I think the video would've been better off without filmburns. In terms of action sports, it's pretty heavily frowned upon to use film burns now a days. Cutting a clip to the audio is much easier on the eyes than a film burn
Clean audio cuts and film burns create totally different vibes though. I am guilty of enjoying the organic feel of a film burn if it fits in right. Sometimes you don't want it to simply be easy on the eyes.
Go buy a bolex and change your film in the sun, shoot a bit of the roll for something useful, send it to a scanner, send in a HD, pay for the film scan, get your hard drive...and bam, film burn.