FLC OF MLG ENTERED AND HELD HOLDING CONTRARY TO HOLDING INSTRUCTIONS AFTER MISSED APCH DUE TO ARPT FOG.

Narrative

WE HAD FLOWN THE RED EYE FROM SFO TO CLT AND WERE TIRED; AS CAN BE EXPECTED. WE GOT THE ATIS AND THEY WERE LNDG S IN CLT. A NEW ATIS CAME OUT AND THEY CHANGED THE LNDG RWYS TO THE N WITH WINDS CALM DUE TO NOISE ABATEMENT. HOWEVER; RWY 36L AND 18R WAS 0 RVR IN FOG AND THE END OF RWY 36R COULD NOT BE SEEN FROM THE TWR DUE TO FOG. BUT THE TWR VISIBILITY WAS 2 MI OUT OVER RWY 18L. THESE WX FACTS WE SAW AFTER WE MADE OUR FIRST APCH TO CLT. AS I MADE THE APCH TO RWY 36R 2 OR 3 ACFT IN FRONT OF ME MISSED THE APCH. AS WE REACHED THE DECISION HT WE ALSO MISSED AND SHORTLY AFTER WENT INTO CLR SKY AND SAW THE TERMINAL; TWR AND 3/4 OF RWY 28L INCLUDING THE LNDG ZONE. CLT TOLD US TO TURN L AND FLY A HDG FOR THE MISSED APCH. WE TOLD THEM AN APCH TO RWY 18L WOULD GET ALL OF US IN. 1 MI FROM A FIX THEY ESTABLISHED AT 15 DME ON THE CLT 270 DEG RADIAL THEY GAVE US HOLDING INSTRUCTIONS. I ENTERED THE HOLD BUT I'M NOT SURE IT WAS ENTERED OR HELD CORRECTLY BUT CLT SAID NOTHING TO US ABOUT IT. WE WERE ABOUT TO PROCEED TO OUR ALTERNATE WHEN CLT CHANGED THE RWY BACK TO RWY 18L AND VECTORED US BACK FOR THE APCH. THEN THEY VECTORED US TOO CLOSE BEHIND AN ACFT AND HAD TO VECTOR US BACK AROUND FOR ANOTHER APCH WHERE I GOT RWY 18L IN SIGHT 2 MI FROM THE ARPT AND LANDED. ALSO DISPATCH HAD CHANGED OUR ALTERNATE AFTER THE HOLDING PATTERN GIVING US MORE FUEL. THIS ENTIRE MESS WAS CAUSE BY CLT NOISE ABATEMENT. SAFETY SHOULD BE FIRST AND WITH THIS IN MIND CLT SHOULD HAVE LEFT THE ARPT IN A S OP BUT I FEEL THEY CAUSE 75 PERCENT OF THEIR PROBS BY HAVING US MAKE APCHS TO RWYS THEY KNEW WE WOULD MISS APCH ON IN THE INTEREST OF NOISE ABATEMENT.