http://nwvault.ign.com/Files/modules/
I'd suggest that you start here. There are thousands of free modules available for download. I'm not big into single player, but I'm sure some of our illustrious members can help you out. I would suggest that you start with the Hall of Fame modules though. Rankings were set by the community, so they were pretty popular.