Never had any issues with my controllers (8bitdo SN30 Pro+, Gulikit King Kong 2), tho they all present as Xbox controllers if you want them to. I don’t currently own any Playstation controllers so I have no personal experience with using them on linux.
Davinci Resolve works just fine for me on Linux, and if you’ve got an Nvidia card and install the proprietary drivers it should be fine too. The Only caveat is that the free version of DR on Linux can’t work with H.264 or H.265 encoded files. It can ingest AV1 encoded files, but, at least my install of DR 19 doesn’t show an option to export AV1, only codecs like DNxHR or ProRes or Cineform. As long as you’re not in a real time crunch or anything, you may have to allocate time in your workflow to do a separate file conversion after exporting from DR with ffmpeg or Handbrake or something if you need either of those.
Here is the list of supported codecs for DR 19. They only list Rocky Linux as officially supported, but it works just fine for me on Fedora Linux, and the installer doesn’t seem to be specific to any type of package manager. (For anyone reading this with an AMD card, if you install rocm-opencl, DR will work with that, even though they only talk about Nvidia and CUDA)
As for OneDrive, there’s a tool called rclone that can be used to, among other things, mount cloud storage services as folders. I think it was kinda broken for OneDrive a while ago (or MS broke support for it, im not sure lol), but you could look into that. I never really used OneDrive much, so I can’t speak much about my experience with it.