Modern games are far too large to fit onto CDs and DVDs. The Witcher 3 was released on DVD and there were over 10 DVDs in the case.
On Blu-Ray you have a better chance, but that's a lot more expensive.
If you stick to smaller games you can make it work, and just write a simple batch/bash script to auto-launch the installer.
There's also a good chance those old Discs you have laying around won't actually work anymore. Discs rot even in an un-burned state.