Assuming they are burned discs, you should be able to simply copy the data straight from the disc onto a computer.
Once the data is on your computer, you should be able to open it with pretty much any video editing software. And as you are wanting to perform advanced editing and effects, your best bet would likely be a full featured product.
Reviews of current software here ( The Best Video Editing Software of 2017 | PCMag.com
) and here ( The Best Video Editing Software of 2017 | Top Ten Reviews
) and other options here: https://filmora.wondershare.com/vide...e-windows.html
If you have specific editing questions or want better guidance, take a look at the forums over at videohelp.com