Automated self-loading cargo carrier for vehicles