It's worth noting that WordPress 3.1 introduced some of this functionality built into the editor. The link panel includes an "Or link to existing content" toggle that shows a live search area for finding and linking to existing content of all post types.