Understanding water saturation levels in tight gas carbonate reservoirs is vital for optimizing hydrocarbon production and mitigating challenges such as reduced permeability due to water saturation (Sw) and pore throat blockages, given its critical role in managing capillary pressure in water drive mechanisms reservoirs. Traditional sediment characterization methods such as core analysis, are often costly, invasive, and lack comprehensive spatial information. In recent years, several classical machine learning models have been developed to address these shortcomings. Traditional machine learning methods utilized in reservoir characterization encounter various challenges, including the ability to capture intricate relationships, potential overfitting, and handling extensive, multi-dimensional datasets. Moreover, these methods often face difficulties in dealing with temporal dependencies and subtle patterns within geological formations, particularly evident in heterogeneous carbonate reservoirs. Consequently, despite technological advancements, enhancing the reliability, interpretability, and applicability of predictive models remains imperative for effectively characterizing tight gas carbonate reservoirs. This study employs a novel data-driven strategy to prediction of water saturation in tight gas reservoir powered by three recurrent neural network type deep/shallow learning algorithms—Gated Recurrent Unit (GRU), Recurrent Neural Networks (RNN), Long Short-Term Memory (LSTM), Support Vector Machine (SVM), K-nearest neighbor (KNN) and Decision tree (DT)—customized to accurately forecast sequential sedimentary structure data. These models, optimized using Adam's optimizer algorithm, demonstrated impressive performance in predicting water saturation levels using conventional petrophysical data. Particularly, the GRU model stood out, achieving remarkable accuracy (an R-squared value of 0.9973) with minimal errors (RMSE of 0.0198) compared to LSTM, RNN, SVM, KNN and, DT algorithms, thus showcasing its proficiency in processing extensive datasets and effectively identifying patterns. By achieving unprecedented accuracy levels, this study not only enhances the understanding of sediment properties and fluid saturation dynamics but also offers practical implications for reservoir management and hydrocarbon exploration in complex geological settings. These insights pave the way for more reliable and efficient decision-making processes, thereby advancing the forefront of reservoir engineering and petroleum geoscience.