There are a lot of cool websites that use Flash for more than games and video these days. Qwiki won TechCrunch Disrupt last year. Beatlab is a super cool music creation app.
And Flash will likely always be the standard for DRM Video on the web. Being an open standard, HTML5 can never include DRM.
I see Flash's place is as a stopgap for features that haven't been standardized/implemented yet. It does those very well.
Flash file uploaders also tend to be more mature and a little smoother to use in general. I'm sure HTML5 will surpass it soon enough, but at present, it's a use of Flash that I don't mind.
Additionally, I somewhat dread the day when annoying and/or malicious advertising makes the switch. At present, blocking Flash is a stupid simple task, a standards based annoyance has the potential to be much harder to avoid.
The only thing that Flash is used for that real people (as opposed to marketing twerps) actually like is cheesy little games, and they can be done perfectly well without Flash these days.