Should I drop MS_DataCollectorInternalUser in msdb?
MS_DataCollectorInternalUser is not an orphaned user. Is a user without a login, a different kind of beast. I suggest you update your security practices, you may have already dropped other valid non-orphaned users. Unless you have a specific security bulletin quoting a reason to drop or modify this user you should leave it in place.