Inchoo_ProductMetaRobots is a Magento module illustrating usage of setup resource installer script to add custom product attributes. In this example user gains per product control over meta robots tag trough Product Information -> Meta Information admin interface.
For more details you can visit my article at inchoo.net.