While I have my own wishes for Carto, and agree there should be improvements, I see it more as a basemap, besides a rendering benchmark, and editing QA. For raster tiles, an overlay may be more suitable, as seen in OpenRailwayMap, and OpenSeaMap. Then you can show them on any background you want, including with OpenSeaMap, Whitewaters, sports, fishing, AED, fire & rescue, and bathymetry plus waterways or watersheds. The latter can extend to rainfall, flooding, storm surge, wave overtopping, tsunami, etc.