EDIT: Thank you so much everyone! There’s so much help for me here, and I’ll recommend anyone with similar question as me to read the comments

Basically title.

I have the DVDs and I have the hardware to burn them to my PC.

But the file size is too much. What software would be ideal to get the best quality with the lowest file size?

I’m going for file sizes per movie at around 2-3gb max.