A standard CD-ROM has up to 360,000 sectors that hold 2 KiB of data each, making the total capcity 703.125 MiB. Anything larger than that is almost certainly a DVD or a Blu-ray, and Windows does not distinguish between those two.
There is probably some tiny DVD somewhere in the world that will still be misdetected, but I'm not sure that issuing SCSI commands to the drive to try to determine the disc type would be any more reliable.