If you are looking for weapon tutorials I have a complete custom weapon tutorial. It covers modelling, unwrapping, texturing, animating, sound FX, and tagging the weapon.
I also have tutorials covering ammo pickups, muzzle flashes, reticles, etc...
If you are interested you can find a complete list in the OP of my tutorial thread here:
http://forum.halomaps.org/index.cfm%3Fpage=topic&topicID=42693------------------------------------------------------------------------------------------------------------
The complete custom weapon tutorial is quite long, if you just want to see certain parts here is a rough "table of contents"
videos 1-6 cover modelling the weapon.
videos 7-9 cover unwrapping (goes over a little into 10 as well).
videos 10-17 cover texturing.
videos 18-26 cover animation (goes over a few minutes into 27).
videos 27-29 cover sound FX and tagging.
The follow-up tutorial adds rails, camo, a supressor, and a useable holographic sight to the weapon from the first tutorial (models and textures). It also changes out the firing sound for a suppressed fire sound, and adjusts the animation for looking down the sights.
------------------------------------------------------------------------------------------------------------
I also take requests for new tutorials, I have a short list of requests that I am currently working on. If you have any additional requests please post them in the forum thread linked above.