If custom assets could be uploaded with the workshop submission, all the assets would be in one place.
If custom assets could be updated, changes could be propogated across all instances of the object.
What we have right now is essentially the worst of both worlds: One where 50% of workshop submissions are broken due to dead URLs, but active creators cannot take advantage of the fact that assets are hosted separately from the workshop submission.