Quantifying Confinement Effects on Fluid Transport and Wetting via Multi-Scale Simulations with Applications to CCS and Hydrates Management