I am going to throw in the dark horse which is PhotoLine

and for raw developing RawTherapee.
My current experience in image compositing and processing covers Photoshop, PhotoLine, Affinity Photo, and (yes) GIMP. I use Photoshop at work (if I must) because it pays for its rent. We never EVER put anything on Adobe's 'cloud' --> servers. The latest uproar about Adobe's intentions with your files only proves us right.
Anyway, the short of it: I prefer PhotoLine for most work and RawTherapee for intricate raw processing.
The long of it (sorry, it's a LENGTHY long one):
@Ambrosia7177 As far as I can tell your requirements in a nutshell would be:
- the need for an image editor/raw developer that can grow with you into the realms of professional in-depth image processing. No corners cut!
- full 16 bit and 32 bit per channel support
- excellent colour management
- hand holding is not that important, but a good community where help can be found is.
- no renting nonsense. Perpetual license, and easy licensing. Preferably no internet required for licensing.
- excellent web output that conforms to the latest web image output formats. And great previewing of the web output.
- (reading somewhat between the lines) excellent image file batch processing with recorded macros option)
- a non-destructive workflow that doesn't affect the original image data, and allows you to always return to each step in the process.
Obviously Photoshop is out

. And not only because of the rent-your-software mess and the new "we will steal your uploaded to the cloud work for our purposes" licensing. Photoshop still can't do full 16 bit processing in its 15 bit (plus one bit) so-called "16 bit" mode. Basically, any conversion of a 32bit image or HDR image to 16bit in Photoshop is silently downgraded to 32769 values instead of the expected double range. This may not be an issue for raw developing, but does potentially get to be a problem when working on HDR stacking.
The secondary issue is that Photoshop (and Lightroom) don't fare very well in web export. Avif support is still not integrated, which is essentially the answer to your web hosted photography in regard to quality AND file size. Nothing beats it.
And I agree with
@r.harris1 's post in that if one is bloody serious about raw image developing and processing, a dedicated raw developing application is probably your best bet, and then send the developed image to your image editor for more detailed edits and colour management.
So LightRoom is also out, since it is rental only.
How about Affinity Photo?
Raw processing is pretty good, if limited compared to a dedicated raw processor. It is also non-destructive in V2, so the raw file is embedded in the file itself, and it can always be re-adjusted later if required.
Colour management is a bit of a hit-and-miss in Affinity. Too much to go into, but read up about it in the Affinity forums here:
https://forum.affinity.serif.com/in...ke-in-adobe-and-other-prof-software-packages/
My own experience with Affinity Photo is that the devil is in the details: things look so
nice starting out, but quickly turn frustrating and down-right ugly once one wants to hit the bare metal and get down with some REAL serious image processing. Limitations soon are revealed.
Now, it's improved somewhat in V2, but still I can't use it for most of my professional work. Then again, other peoples mileage may vary, of course. I do use Affinity Photo for certain things, and it definitely has good points. The lighting filter is grand, for example.
The community is nice, and very helpful. The Affinity forums are all you need, even if some participants lack empathy and might become sensitive when their beloved Affinity Photo is criticized.
Lastly, web export in Affinity Photo is... well... let's say 'problematic', which sums it up nicely. The web export workspace doesn't do previews. Yes, you have read that correctly: no preview of the output result.
Instead, a hastily put-together file-->Export option does feature such a preview, but without any way to compare between the original or another version.
Remember Photoshop's classic web export dialog? That was (still is) a good web export dialog. Simple, to the point, and with options to preview and compare output formats. Affinity's export dialog is like something we would call in agile development a MVP0 affair. Barely usable, no comparison options, and it's not even possible to control the preview with regular GUI controls to zoom in/out.
Web export control and previewing is not up to expectations. Not even for a quick photo/image web export. At least, not in my book. And as I mentioned before: avif web export remains unsupported. Terrible.
Batch processing is actually really good, with macro support. Unfortunately, the choice of export formats is REALLY limited: only JPEG, PNG, TIFF, OpenEXR, WebP, and JPEG-XL. That's it. No PDF, no Avif.
And the core workflow is mostly non-destructive, with some caveats here and there. But improving.
And PhotoLine?
Obviously I am biased, because it is my image editing workhorse. Once upon a time I was a Photoshop zealot and devotee. I mean, I LOVED working in Photoshop. And in Illustrator, Premiere, Afx, ... Loved it all. Taught these apps at a high level at colleges and universities.
Then the first rent-your-software Adobe CS6 happened. And I foresaw what would happen: rental only. So I looked for an alternative for my freelance and hobby stuff. Went through everything, and nothing would even come close to my requirements. Affinity did not exist at that time - not for years. Then I (accidentally) bumped into someone's post about an obscure image editor called "PhotoLine". I did not like the name. I visited their website, and immediately thought "WTH, this is junkware. That site is ridiculously primitive.".
But I hadn't discovered a good alternative yet, so this was pretty much my last resort. I downloaded it, installed it, and on my first try I cried out loud from joy: even at that time it could do things I had never seen before in an image editor! Layer opacity range from -200 up to +200! Layer mask layers that could be nested, combined, whatever! Layer cloning! Reuse clones for masks! Great curve editor and even the ability to work with curves in other image modes than the image mode! Full vector support as if Illustrator had merged with Photoshop. And more!
But the GUI was... very primitive. And PhotoLine was still missing (a lot of) stuff that I would expect. But the core of the app just felt SO right. So I started my transition, which took 2 years, or so, from Photoshop to PhotoLine.
The forums were very helpful though, and most surprising the two developers are incredibly responsive to requests for improvements and new features. Since I left CS6, MANY of my requests and suggestions, along with other professional users, have been implemented throughout the years. I have NEVER before (but for Blender's community of devs) experienced such willingness to implement new and improved features based on users' requests.
More than once I requested for a change or an addition, and the next beta it would be available. Bugs are immediatly squashed after reporting in the next beta. And the beta is openly available. It has progressed greatly since that very first version that I tried, and is barely recognizable. The GUI and core workflow is extremely configurable. (Granted, I find the default setup to be less than... optimal)
The worfklow mostly non-destructive.
Anyway, so much for my personal journey with PhotoLine. How does it hold up in regard to
@Ambrosia7177 your requirements?
Web export is excellent. Avif is supported. The web export dialog leaves little to desire and it is possible to hook recorded macros into your web export as well. Two web output versions can be compared with the original. And some very deep support for PNG and other web formats. PhotoLine is also very friendly towards other applications: files can be directly sent to other image editing apps. It's a simple setup.
Colour management is fully implemented and mostly non-destructive.
Raw image photo development is non-destructive. Compared to Affinity Photo it requires a little more manual work. PhotoLine can open raw files as linear unmodified non color managed source images - not something many raw processors manage or allow for.
But I don't do my important raw processing in PhotoLine. Read below.
Batch processing is great, with macro support. And a LOT of image file formats are available. Including PDF, PSD, and Avif!
PS PhotoLine's PDF support is excellent. It can behave like a color-managed PDF editor. PhotoLine features basic DTP features and great prepress control. Although I use PDFexchange Editor myself for critical PDF work (unfortunately Windows only).
The community (forum) is the main hub of activity. The developers and users are very helpful.
However, PhotoLine still remains a relatively obscure entry on the market. Almost no tutorials on YouTube, for example. There are one or two tutorial websites aimed at PhotoLine, but that... is it. No books. No tutorials done by professionals. No courses. It is the great conondrum. I still intend to do a professional course for PhotoLine, but time is lacking. ;-)
The licensing is awesome, though: no internet required to activate. Just a traditional serial number. And PhotoLine can be installed portable on a USB drive or key. I take it with me whereever I go (both the Mac and Windows version). Plug it in, and I can continue my work with my custom settings.
www.pl32.com
What about raw image processing then?
RawTherapee is the one I use. Free, open source, very capable, professional, and a non-destructive workflow. Outstanding licensing, i.e; free! Open source!
https://rawtherapee.com/
My pipeline: Explore the folder with RAW photo images, double-click the one to process. Adjust settings (or use a preset I built previously). Then click on the sent-to-external-app button. It opens in PhotoLine. Further processing, and finally export to the web as Avif. This can also be automated for a large part via macros (or AppleScript/VBScript, if so required).
And the entire workflow is non-destructive. PhotoLine features an option to save output formats together with a sidecar PhotoLine document, and it behaves as if (for example) an output format such as JPG suddenly maintains full editability with adjustment layers, filters, masks, and so on. Again a boon. Not possible in other image editors.
...again sorry for the long post. I just feel PhotoLine deserves more exposure online in my opinion. It is the only image editor that can keep up with me. Even Photoshop feels awkward to work with nowadays for me because it misses these things that I can pull off easily in PhotoLine.