I've done a tiny amount of video (Blackmagic Resolve) and a ton of Lightroom. One problem you have is that there are competing issues, notably I'd want redundant raid for images, but that's slower.
For video and Resolve, a huge issue is GPU(s); it heavily depends on them for rendering, especially with a lot of nodes in the color grades. It will likely be a limiting factor more than the disks, though they come right behind.
Let me answer Lightroom first as I'm more confident there. The Preview Cache, ACR cache, and your scratch and temp should be on either a single non-raid SSD, or a Raid-0 SSD. When there is a disk bottleneck, they are usually it (especially during interactive use as opposed to big exports). The preview cache has to be moved with a soft-link, as by default LR will only put it next to the catalog (which IMO should be on a raid-1 for safety). The actual image files do not matter a lot for LR, though for Photoshop if you are writing back large TIF's, having them on faster disks helps a lot. I kept all my images on slow spinning disks for years, and just changed to SSD, and frankly can't see a difference in that respect but most editing is in LR (which doesn't write big TIFF's normally). Putting the catalog file itself in faster disk does help quite a bit in some operations, though not develop (which is where most people feel LR is slow).
For most things single core speed is the biggest bottleneck for Lightroom, not disks.
My biggest concern in the above is that you have no apparent setup for any raid protection for your data. If that's OK with you, great. Just think about it.
With no raid at all, the fastest thing is the M.2 card, so I'd put your caches (Resolve, Photoshop ACR, Photoshop temp, LR cache) there as well as OS. Then just spread the rest of the load as widely as you can, observe which disks are busy and consider relocating things as you observe how they vary with your own workload. Static images (raw files not being actively changed) on the spinning disks, though you might move big video files to fast disk while you are editing them.