Umm, can't really think of anything.
most oblivion quest mods fit under:
fetch
dungeon crawl
puzzle
character/companion based
stealth/assassination
misc
So it's mostly just close quarters combat, or things that don't involve much combat.... hard to think of something with a ranged specification, or where ranged proves a significant asset...
I can only think of 2 really:
http://www.tesnexus.com/downloads/file.php?id=26723 (never tried it, not a quest mod but it comes up whenever someone talks about rangers or bows)
Five blind mice (http://www.tesnexus.com/downloads/file.php?id=24580l, and http://www.tesnexus.com/downloads/file.php?id=35248) It's a close quarters dungeon crawl with a lot of enemies, and you get a bow which is the only thing that can hurt the enemies there.
Also check the http://www.gamesas.com/index.php?showtopic=1010109. It has one list devoted to roleplay, one list devoted to stealth, and a whole bunch of others.