Okay, so here is what I can think of off of the top of my head:
Dungeon issues #
118 Box of Flumph - a little silly, but not much combat
121 The Styes - good bit of exploring with a slant towards investigation in a neat urban setting
128 Shut In - stuck in a house with creepy old lady and her "pets"
129 Murder in Oakbridge - great murder mystery (Eberron, but it has notes to change that)
133 Chimes at Midnight - stop the mastermind villain (Eberron, but it has notes to change that)
I ran "Shut In" as an Ars Magica adventure and it worked great. But as with all Dungeon adventures a little fine tuning and removal of some of the unneeded combat encounters replaced with more investigation, exploring, and chatty encounters is usually not too difficult. But all of these need very little tinkering (if any).
138 (has some nice adventures with less hack 'n slash, but all have more combat than the others I've mentioned)
- Urban Decay - Wererats, sewers, and some investigation
- The Weavers - another Styes adventure
- Mud Sorcerer's Tomb - exploration, traps, and puzzles
- Challenge of Champions VI - as mentioned above, no combat
I don't have access to any non-Dungeon modules at the moment...
EDITED to add issue #138