Carbon capture and Storage (CCS) plays an essential role in global decarbonisation. Accurate monitoring of injected CO2 volumes and migration is critical for the success of carbon sequestration projects. Geophysical measurements using time-lapse seismic surveys, well logs, core experiments, and reservoir simulations are widely used to monitor CO2 behaviour (potential leakage, plume movement, pressure, and saturation changes) over time for CCS sites. Supercritical CO2, exhibiting a hybrid of gas and liquid properties, is injected into the system. Seismic responses are susceptible to even a small concentration of gaseous CO2, thus making it difficult to pinpoint saturation numbers. The accuracy of a rock physics model heavily relies on the input parameters, such as rock properties (porosity, permeability) and fluid behaviour, which are often uncertain and can lead to inaccuracies in the predictions. Mostly, a homogeneous fluid distribution assumption is employed which may deviate from realistic CO2 saturation scenarios because of existing heterogeneities and in-situ conditions. This assumption might lead to a distorted saturation profile, uncertainties in the volume of CO2 injection, mismatch with actual field results, and long-term monitoring. In this paper, we focus on the choice of the fluid distribution model and how it impacts the characterisation of CO2 saturation mainly for the Quest CCS, Alberta fields, and the classic Sleipner, North Sea, project. We find that the two saturation states (homogeneous and patchy) at different durations of a CCS project can be captured using a capillary pressure-based rock physics model. We validate our results using core and well-log data, and we also observe the effects in reservoir simulation models. In the spirit of addressing the non-uniqueness of saturation analysis, this modeling strategy has the potential to become a key method for robust subsurface CO2 saturation monitoring.