Good solid motors. Definetely not junk. Parts may be harder to get for them, but I doubt it's that hard, especially since essentially the same engine was used in lots of ag applications. Might take some research, but that certainly doesn't make the engine junk. Quick search shows results for gasket kits, rebuild kits, injectors, injection pump is a standard Bosch (MW or P), so any shop can get parts, etc etc.
IMHO the reason you don't see a lot of parts is the simple fact that they don't sell any because they just plain don't need them - they don't break.
The 6.6 is a bit underpowered, 7.8 is decent. Stock power options of 210, 240 & 270 HP. Difference appeares to be limitted to the turbo and intercooling (later ones had an intercooler on all motors, earlier only had it for the 240/270 HP) - 90 may be either way. Turning up the fuel and bumping the timing up helps a lot with power too. MW or P pump - 90 is probably a MW pump, but still good.
I have a 7.8 in what was a box truck and is now a crane/flatbed. It's got just shy of 600k miles on what appears to be an all original engine and it runs strong still - no smoke, starts right up, has decent power. IMHO it's pretty on par with the DT466/8.3. Certainly a tough motor, I overheated the snot out of mine trying to get up Tehachapi pass in the middle of summer (110* air temp) with a broke fan clutch pulling about 50k gross. Handled it just fine and no damage or issues since.
ASFAIK, 7.8/6.6 are not wet sleeve, they're patent bore engines. That being said, wet sleeves really don't matter that much. The only real benifit is being able to in frame an engine vs pulling it - something that matters when it's a commercial setup, but is much less of an issue for a home/hobby use. How often are you really going to rebuilt it? For most of us, once if at all.
Haven't heard anything about cam problems. Might have been an early engine issue. Just like anything else, there's undoubtedly improvements over the production run.
Bottom line, I wouldn't have any issues getting another.
Now, a better question becomes what are you doing with it? You mention putting it in a semi - that's a pretty small engine for a semi. It's a good MDT engine, but given a choice I'd go with something bigger for anything over a bobtail MDT. Beyond that, making it all work is going to probably be a pain - easier to get a complete semi and/or a motor that came stock with all the assorted bits you need.