I feel like you're hearing a ton of software recommendations and we're still not totally clear on your workflow or what you're trying to do.
You mention that you currently have around 700-1000 photos to sort through and edit. Apple Photos can do that but it'll be slow going. Some examples as to why:
1) You can't view more than one photo in a large size at a time. If you're the type of person to burst-shoot or even take photos in quick succession then you're going to want to find the optimal photo out of a pack of very similar photos, and the best way to do that is to view as many of those photos as large as you can. If you're more "disciplined" with the shutter button then this feature may not matter as much to you.
2) Editing a photo triggers a fancy animation and brings up an editing screen. That's a waste of time. With dedicated photography software (Lightroom, Capture One) the editing palettes are up at all times, and you can customize which tools are shown, and in what order.
3) You can't transfer edits between photos. For an example of how this is a useful feature, consider this: what if you took a photo and the white balance was off? Or what if the lighting washed everything out, and you restored the appearance by increasing the contrast and saturation? With Lightroom or Capture One you can manually edit one photo, then lift the adjustments from that photo and apply them to any number of photos that you want, all at once. Now instead of opening each photo one by one and adjusting the same sliders over and over, you've saved yourself a bunch of time.
Those features are helpful if you're doing high-volume photography. If you're generally only going to be doing 1-20 photos at a time then those features may be overkill, and Photos or even Finder and Preview might work just fine for you.
Similarly, consider what you're trying to edit with your photos. I use Capture One and most of my edits are limited to general scene adjustments. I'll occasionally clone something out, but I'm not doing any major manipulation of the image. As such, Photoshop (or my preferred Mac alternative, Pixelmator Pro) represents major overkill for my needs. At this point I only use Pixelmator if I'm assembling a diptych or triptych, really. I just don't have the time or inclination to do very heavy, focused editing on single images.
I don't like subscription software, hence my choices of Capture One and Pixelmator over Adobe's stuff. It sounds like you're in the middle of a whole bunch of things - not a good time to be committing to complex and expensive software. I'd recommend struggling with Apple Photos for now to get a sense of what's working for you and what's lacking. If you really want to splash out into the more specialized software, Capture One (and I believe Lightroom) should offer free trials - make use of at least one of them before spending any money (yes, even despite the Black Friday/Cyber Monday deals). I don't really think there's a wrong choice you can make, but there are certainly sub-optimal ones. You'll know your own needs and budget best.
Good luck!
You mention that you currently have around 700-1000 photos to sort through and edit. Apple Photos can do that but it'll be slow going. Some examples as to why:
1) You can't view more than one photo in a large size at a time. If you're the type of person to burst-shoot or even take photos in quick succession then you're going to want to find the optimal photo out of a pack of very similar photos, and the best way to do that is to view as many of those photos as large as you can. If you're more "disciplined" with the shutter button then this feature may not matter as much to you.
2) Editing a photo triggers a fancy animation and brings up an editing screen. That's a waste of time. With dedicated photography software (Lightroom, Capture One) the editing palettes are up at all times, and you can customize which tools are shown, and in what order.
3) You can't transfer edits between photos. For an example of how this is a useful feature, consider this: what if you took a photo and the white balance was off? Or what if the lighting washed everything out, and you restored the appearance by increasing the contrast and saturation? With Lightroom or Capture One you can manually edit one photo, then lift the adjustments from that photo and apply them to any number of photos that you want, all at once. Now instead of opening each photo one by one and adjusting the same sliders over and over, you've saved yourself a bunch of time.
Those features are helpful if you're doing high-volume photography. If you're generally only going to be doing 1-20 photos at a time then those features may be overkill, and Photos or even Finder and Preview might work just fine for you.
Similarly, consider what you're trying to edit with your photos. I use Capture One and most of my edits are limited to general scene adjustments. I'll occasionally clone something out, but I'm not doing any major manipulation of the image. As such, Photoshop (or my preferred Mac alternative, Pixelmator Pro) represents major overkill for my needs. At this point I only use Pixelmator if I'm assembling a diptych or triptych, really. I just don't have the time or inclination to do very heavy, focused editing on single images.
I don't like subscription software, hence my choices of Capture One and Pixelmator over Adobe's stuff. It sounds like you're in the middle of a whole bunch of things - not a good time to be committing to complex and expensive software. I'd recommend struggling with Apple Photos for now to get a sense of what's working for you and what's lacking. If you really want to splash out into the more specialized software, Capture One (and I believe Lightroom) should offer free trials - make use of at least one of them before spending any money (yes, even despite the Black Friday/Cyber Monday deals). I don't really think there's a wrong choice you can make, but there are certainly sub-optimal ones. You'll know your own needs and budget best.
Good luck!