[Colossus] Add timeout enhancements to `superagent` requests based on the object sizes

[zeeshanakram3]

Address this comment https://github.com/Joystream/joystream/pull/4998#issuecomment-1851633733