NO, way back in prehistoric times you speak of, I was an IT engineer, and that was not the case at all. File "type" means nothing to a hard drive, it has to access data the same way no matter what "file type". What you stat is a misunderstanding of the technical facts. Let me clarify. And no, the practice is still technically sound today.
The rule-of-thumb was to put your NLE and media on a separate drive from your system drive. And that reason stands today. It is based on the bandwidth of the connection between the drive and the CPU. Just like your Internet connection, you have a limit to how much data can flow upstream and downstream (or upload and download). The system drive has the operating system and the running applications writing invisible "working files" non-stop to the system drive. Not to mention the Virtual RAM that macOS uses your system drive for, also. All of that work goes on non-stop, 24/7 and eats up bandwidth between the system drive and the CPU.
Video editing is one of the most demanding on storage drive bus bandwidth. It has to stream multiple video and audio data streams live, plus read/write to it's own database, etc. It eats up a ton of bandwidth between the storage drive and the CPU. Thus, you use a secondary, FAST storage drive for your NLE's project files, media, and with FCPX the Libraries. This helps general system performance stay as efficient as possible, by allowing the OS an apps all the bandwidth they need to work, limited only by the system drive's abilities.
A photo library like for Photos or Lighroom don't really need a secondary drive, as they read an image into RAM, write changes to the drive, pop one, pop two, done. Photos don't need to stream media real time, just load a static image and done. So a photo library on a system drive won't effect anything.
THAT has been true since the beginning of the personal computer, and is true today. But "file type" means nothing and has no effect in this matter. Accessing a JPEG, a MOV, a DOC or a PDF means nothing to system efficiency, it is the speed at which those need to be read and written that matters. Putting different "file types" on different drives makes no technical sense. But putting NLE files on a separate drive from your system drive makes tons of sense.
So that secondary drive today needs to be minimum a 7200rpm spinning disk drive, larger the better, RAID is better (more bays the better), and USB 3, preferably Thunderbolt (any version). SSD drives are faster, but I don't recommend them as, even after all these years, the promise of them becoming affordable and large has not panned out. They're expensive and small, and unless there is a technical need for them, I'd say save your money.
If you remember the old IBM Big Blue computers, that required an amp/ohm meter for troubleshooting, and a soldering iron to repair, you know how old I could possibly be, and how far back my IT engineering experience goes.