The 3d rotating view thing seems to be powered by something called ThreeKit. It's probably achievable through html/css, but a web development sub is probably a better place to ask.
As for the video, there are many producers out there, shouldn't be hard to find one. As for software DaVinci Resolve is my go to, this could probably be done in the free version.
I used Gimp a couple times but i have to admit i never really learned to use it.
I did most of my editing in Lightroom and since about 1.5 years in Capture One Pro. I only use Affinity for about 5% of my editing time, since most of the time Capture One is enough.
I find Affinity way more user friendly to work with than Gimp (This could vary a lot since you know Gimp probably way better).
"Special" tools i used that are great IMO:
- Focus Stacking, Panorama Stitching, Macros, split toning
Probably the best you can do is download the free trial and try for yourself (scroll all the way down):
https://affinity.serif.com/en-us/photo/
My current workflow for backing up is to use restic which I use to encrypt and sync to Backblaze B2
For categorising I've tried a few apps, including Dark Table and ON1 but I've since settled for the built in Mac Photos. Surprisingly, Photos actually does most of what I want with the latest version of MacOS. Affinity also has some extensions that integrate with it too which is quite nice.