For text tgp's I wholeheartedly recommend Autogallery SQL from
http://www.jmbsoft.com
It's stable, has good support, and gets frequent updates adding new functionality.
If you are going for thumb tgp's then I would recommend smartthumbs
http://www.thumbsrotator.com