Marking this as Partially Implemented as the primary request has been full filled and that was simply exposing the data. I'll be modifying various blocks, modules and widgets to take advantage of this by being able to enable/disable the attachments (saving a query for those that don't want to use the images).
All Widgets, Blocks and Modules that display items in "List View" now have the option to "Display Thumbnail". Attachment Data is only exposed when enabling this option (which saves 1 query for those that don't want to display images). I'll post screen caps once the Template(s) are final.
IMPORTANT NOTE: This excludes XenPorta at the moment as Jaxel has not updated XenPorta to work with xf 1.2 yet. I will update XenPorta Blocks as soon as possible once a new version of XenPorta is released.