Puh, lots of questions and a lot to answer. Maybe I’ll forget something, then please ask again.
First of all, right, looks all messy, to me as well, but you have to understand that this is all historically grown over the last decades since the founding of Steinberg. Please keep that in mind.
That files from the same sound library are to be found in different subfolders is due to their “functions”. The biggest part of a sound library are the raw samples of the instruments. So e.g. a piano is sampled at different dynamics, then there must be some meta data which tells which of the samples is to be played when MIDI note on commands come in with different key velocity values. So all this information is what makes out of some raw samples the real sound, the sound patch, or - as we call them - the presets.
So you see at some stage it was decided to keep the preset data in one folder and the raw samples in another. And if you really want to untangle this “mess” on your external drive, you can do that, you can put any file anywhere you like, but adjust the alias to the original file.
And as already mentioned, some files don’t belong to a sound library, but Dorico resp. Cubase or other programs expect them at certain locations, so if you move out a file from the default install location, you need to replace the original file with an alias that points to the new location. It’s tedious, sure, but that’s what the Steinberg Library Manager was conceived for, you click one button and the manager does the rest for you.
Now, why does Dorico sometimes complain about missing content, but Cubase does not?
Well, Dorico keeps a list of *.vstsound file which carry preset data and checks for the presence of all of them. That is just a service of Dorico and to warn users, they might get no proper playback because some vstsound file is missing. Cubase does not do such check at start-up, it does not care. Because at the end of the day all vstsound files are optional. Cubase or Dorico will still be able to operate even if they are not there (but then with limited functionality.)
Next you ask: “I should move these files manually to my external SSD, […]?“ Well, I say it is up to you. But if you do, you better follow my advice about creating proper aliases.
Then you state: “It would be fantastic if I could just use my folder SteinbergContent […]“ I’m not sure on that, but in theory that could work, but then you have to keep on your external drive the exact same folder structure as there is/was on the internal drive.
My suggestion though is, why don’t you leave everything as it is right now? The majority of vstsound files (especially the big, giga byte sized files) you have already external, and that what is still on your internal disc, is so tiny, compared to the rest, it won’t make a big difference. But this is only my opinion. I’ve explained the background, you decide what to do.