I’ve used Y connectors in the past and have not noticed any significant level drop – but maybe I just didn’t notice – most of my experience was with an ME66 which is a very hot mic anyway.
My question about noise was really to do with the cameras preamp – if the level drops significantly then I would expect the signal going to tape to be noticeably more noisy. I’ll do some testing with my setup – thanks for the input.