At my company we created an auto loading video that all the devs agreed was terrible. It was compared, statistically, to one that didn't auto play. Sure, 10% of users left immediately, killing traffic, but revenue increased more than the traffic dipped. It's still auto playing on that page.

I agree that browser makers should fix this. It should probably behave like the location API and be remembered by domain or something.