Well quite honestly I believe any module I’ve played is a module that could be played with kids. I’m not sure what Scot is defining as “kids” but I’ve not run across anything inappropriate for kids (maybe 8+ years) in any modules I’ve seen. Now to be completely candid, I’m not a fan of “adult” themes in my roleplaying games. I don’t want anything too graphic as far as violence or sexuality, and while I do like some politics in my games, I don’t need deep intrigue and espionage to enjoy the political aspects. While I acknowledge there are those out there who enjoy these things, they’re just not really for me.
If I had to choose one module that I think has perhaps the best feel for me as something I’d want to run for young kids (8-12 years) it would probably be B2 The Keep on the Borderlands. I think this module is a great starting point for kids just getting into the game because it is so self contained. There is a home base, a wilderness to traverse, and a huge dungeon environment to explore. The evils, though vile, aren’t really obscene (unless the DM wants to go there). There are just really fun fantasy tropes in abundance and a really good overview of all the aspects of the game. Not only is this a teaching module for the Dungeon Master, but I think it is a teaching module for players as well. It lays out all of the aspects of the game and walks the characters through them bit by bit.
I’ve made no bones about the fact that The Keep on the Borderlands is one of my all time favorite adventures and that is largely because it was my first adventure into the world of Dungeons & Dragons role playing and that is hard to ignore, but it is also just one of the best examples of the art form available to this very day.