The detection and monitoring of diverse water bodies are vital for the efficient management of water resources at local, regional, and global scales, in alignment with sustainable development principles. Remote sensing-based mapping of water surfaces is an effective tool for this purpose, but accurately detecting both open and inland water bodies simultaneously is challenging due to the high spectral variability of these targets. This variability depends on the geographic and edaphoclimatic characteristics of the study area as well as the type of suspended material in the water. In this study, we proposed the MAWI (Maximized Algebraic Water Index) index, developed to improve the detection of open and inland surface water bodies at a 10 m spatial resolution using multitemporal Sentinel-2 satellite data. The objective was to evaluate the effectiveness of the MAWI index in detecting and spatially delineating various types of water bodies (clear, muddy, open, and inland waters) and to compare it with traditional spectral water indices: NDWI, MNDWI, OSWI, SRWI, AWEI-sh, and AWEI-nsh. The methodological steps included creating sample and orbital datasets, calculating spectral water indices, performing a descriptive statistical analysis of target spectral behavior relative to the indices, conducting binary classification based on spectral thresholds, and evaluating classification accuracy against both the analyzed spectral indices and reference geospatial land-use and land-cover data. The MAWI index demonstrated the best performance among the water indices analyzed, with overall accuracy, producer's accuracy, user's accuracy, Kappa coefficient, and F1-score values of 0.9348, 0.9315, 0.9413, 0.8683, and 0.9340, respectively. Compared to the Dynamic World (10 m) and MapBiomas (30 m) datasets, the MAWI index achieved overall accuracy gains of +0.66% and +4.96%, respectively, demonstrating its applicability to future studies on the spatial detection and monitoring of diverse water bodies across different mapping scales.