Photos is an Image Management system, not just an editor. Finder is a File Management System which lets you change file names and keeps track of modification date and stuff associated with files. But images are way more than files, and Photos organizes pictures with creation dates, captions, GPS locations, faces, and more. To do this, Photos needs to have control over the pictures, so they are Managed by being copied into the Photos Library where the database is stored. The Photos Library of pictures can be large, and it can be held on a directly connected external drive-- but not networked, clouded, NASed, etc. Photos interfaces with iCloud Photos, so that all the pictures are available on other connected devices.
Photos is a non-destructive editor. If you edit or crop a picture, maybe cutting off the sides or intensifying the color, the original file is never touched. Instead, your editing steps are stored in the Photos Database. It's the same for every kind of edit, keyword, comment that you do-- the original picture is not altered, but the information is stored in the Database. So the picture you see on the screen never existed as a file-- it is constructed on the fly from the original plus the information in the database.
I also use Lightroom Classic (subscription, bah!) and other editors, but Photos does most of what I need.
I keep my "Library of Pictures" divided into multiple separate Photos Libraries, some of which are entirely archival. I have a Photos Library of only favorites, for instance, that connects to iCloud. I also keep backup copies of all the original pictures on separate hard drives.