I've only ever seen them in airports (where people frequently sit for an hour or more between flights) or in hotel rooms. I've never seen one on a trash can or somewhere that you wouldn't already be waiting for something.

A few years back there was a startup that had kiosks in grocery stores to charge while you shopped (locked into a little cubby hole), but those seem to have disappeared too.