are these security floodlights with built in cctv really any good?

They are quite good. Obviously it depends on what you want to protect. The down side is that the images record to an SD card inside the unit. The up side is they are relatively cheap and provide good quality images. Regards Mark

The Ring options are very good for this, also there are many similar products that records on motion.

ir cameras are very good

CCTV images are based on the cameras capability in low light conditions, increasing the correct light available will help enhance the picture obtained. The lower the lux the better the image in low light conditions. You are more likely to get a very good picture on an camera that's near an out side street lamp than say with the same camera round the back with just infra red leds, extra lighting may be required to enhance the picture quality to an acceptable level.