If you want a simple, no code solution, you could always open Sharepoint Designer.
- Create a blank aspx page on the site collection that holds the list you wan to display.
- Then, using Designer, insert a Data View web part of that list into that page (you can choose your columns, paging, etc in Designer). That creates a page that just shows the list, with no master page and locked content parts, just the list view of the information.
- Then on the destination site collection, insert a Page Viewer web part in, point it to that aspx page and adjust the height and width for optimum display.
It's not the most elegant solution, but it's simple enough for a power user to do (if they have Designer permissions) and one less customization to keep track of. Also, I haven't tried this yet, but it may work for even different farms if you have cross farm permissions and trusts set up properly.