http://www.h2maps.net/
All the custom maps can be found here in the map repo section. As already said in this thread the custom maps go to documents/mygames/halo2/maps folder and not the map folder in the actual game directory. Also you can only have 50 maps at that folder at anytime or...