WP Central has good live tile support. Weave is really good too. WeatherBug and Weather Channel app are two weather apps that I have used, and they are both really good.
Engadget has a live tile as well. I used it for awhile but now the only live tile I use is the Photo one. I found the live tiles that accesses online wore my battery out super fast.
Oh, and Flickr has a live tile too. Much like the photo tile.
Weave, although the app itself was unappealing to me, has one of the best WP8 live tiles. That one actually utilizes the new movements of the Live Tiles, unlike others that still use that annoying flip from WP7...