I've used the Eufy S100. From a distance it looks like a light. Close up it says Eufy Security on the bottom light and the camera is plain to see. I haven't used any other camera/light combination.
It depends what you mean by discreet, normally it should be made obvious to people that they are...