Yeah, non-destructive editing of your archive is the way to go. You can pull from various media and network sources to import your photos/video and it organizes them into whatever folder structure you’ve chosen. The whole point of archiving is to preserve and organize your image collection so you can find your stuff when you need it. The virtual copies with edits can easily be exported in whatever formats or dimensions you want.

Whatever way you go, back it up. I use Lightroom Classic to organize everything by date and process images. I use an internal drive for working on, a NAS for a second on-site backup and a few Pixel XLs to upload everything to Google Photos in original quality without paying for cloud storage. For digitizing you’ll need a ton of patience and some hardware depending on what you’re planning on capturing.