Hybrid Color Glass Condensate and hydrodynamic description of the Relativistic Heavy Ion Collider small system scan