I think the frame you guys are after is the eStarling. It can display photos from an RSS feed over WiFi, so that pretty much supports Flickr feeds, Google Picasa, or even something you code yourself.

It says you can 'email photos to it' which is quite interesting. I hope it is smart enough so you can set it to check any POP/IMAP server you like and not just hardcoded to an eStarling proprietary system. I can imagine a situation where a hacker breaks the eStarling mail server and sends out a horrific Internet meme photo to each user...

It has a big ugly plastic frame and an 'eStarling' logo on the front of it. Probably expensive too. Still, its by far the best one I've come across.