I just discovered webpin, a web based search engine for repositories. Webpin will automatically register new repositories and use libzypp for dependency resolution, leaving you with very little to do, while the packages are downloaded and installed quickly and transparently.
Screenshot of the search engine:
Pretty Cool!
BTW: as you can see Compiz Fusion is now available from the official repository: http://software.opensuse.org/download/X11:/XGL/openSUSE_10.2