Are there any other launchers that display a folder's contents instead of the generic icon?
This won't help people who are still waiting for their phone to be upgraded, but the stock Ice Cream Sandwich (Android 4) launcher has something similar built in - it shows a cascaded view of the first three icons in the folder.