I'm not finding fault with the plugin, I'm asking how to solve the problem with or without the plugin. I only mentioned the plugin as a reference point, so someone wouldn't suggest it to me (because it doesn't solve the problem).
Certainly, there must be people out there who've found a solution because it is absolutely necessary for several applications. For example...
Let's say you want only "Front Page News" items to show up on the front page News section, but you want them also to be navigable so that once a person clicks through, they can go to the next news item without having to return to the front page. This is a standard sort of thing. Those Front Page News items might also need to be listed in a different category like Exhibitions or New Products, etc. It's not sufficient or efficient to tell a client they have to make duplicate pages just to put one post in multiple categories.
I already discussed this on the Wordpress StackExchange around this time last year and someone there said he developed a solution, but I could not get it to work for the life of me. He was kind enough to give me the code, but it did not work. I plan to revisit that soon and see if I can get it to work, but since I found this new forum, I figured I would ask people here.