The strangest autoland I've ever done was in a 777 to Gatwick. The London fog was dense, but it "topped" at only 150' or so, and was CAVU and sunny above. This produced an approach which was surreal. At 1000' AGL, gear and flaps down and landing clearance recieved, the "deck" was still far below us.
The radar altimeter then announced "Five Hundred..." Still, the flat deck was below is. "Three hundred, Two hundred, One hundred..." At that moment we entered the solid weather. Very creepy. Simultaneously, the jet entered its FLARE mode, and moments later touched down. The RVR was less than 1000, IIRC. We then used SMGS to taxi to the gate.
Many 738's with the HUD do Cat3's ONLY hand-flown. During certification for hand-flown cat 3's, the simulator team was required to complete 1000 consecutive landings, each within a tight TDZ. They did this successfully, but it took many hours, of course. Training for HUD landlings in the sim, the Sim IP turned off the visuals, meaning it was totally black outside. It was actually pretty simple to execute a decently soft landing, brake the jet to a halt, and when the visuals were turned back on, there we were straddling the centerline, 6000' down the runway.
Summary - Autolands and Hand-flown Cat 3's down to 300 RVR happen all the time and are a non-event.