I think this is as good as any to explain one reason why apt-get, yum, etc. work. It is not apt-get, yum or any other program if its nature. It isn't even because they are *nix-based. The only reason it works is, well... It's the data, stupid!
tinjaw, while the *nix level of close integration will be hard to achieve, what I actually want to achieve is far simpler. I just need
1) A system to check for new software updates and inform me
2) The system should take me to the corresponding page and let me download the programs
3) It should show me the list of add/remove programs and let me uninstall what I don't want
4) It should list programs based on category rather than as a single long list
The neat thing about *nix package management is the way it handles dependencies and automatically gets the required modules to run the program as well. I am not looking for this feature since most windows programs automatically check and tell you if any other tools (e.g. JRE .NET Framework) are needed.
The grouping of packages is already done by some of the tools listed above. I am having exams over the next month, so I will probably write a review on this by early January, unless someone else wants to do it.