1) OOB solutions:
- Page view : this link any data, interanl or external sharepoint
- CQWP
- DVWP
- List View: I feel this is best option, see my post http://sharepointlink.blogspot.com/2009/03/share-document-library-among-different.html
2) recommeded 3rd party adds-on:
- Coarseworks
- LightingTools
- CodePlex (lookup cross sites)
3) customization:
- roll-up web part
- Search service and search result web part, xsl
However, most of above apply to sites in a same collection. There is very limited options when trying to sharing data cross site collections, which indicates to me anothe point: when designing sharepont taxonomy, data shareing is a very import factor behind sizing and security.