I have a question about tilesets for environments. I'm trying my hand at a first videogame and plan to make levels with Tiled in the brush mode. I have tried making several tilesets that work for the most part, but it seems I am always missing some tiles or having some extra that are unnecessary. I looked for some sort of standardisation and also looked at how other games handle their edges and corners. Link's Awakening for example takes the path of making transparent corners and just slapping those on any environment, which is too apparent. Other games have all sorts of small extra corner tiles which wouldn't work too wel with Tiled.
Is there some sort of standard set that can be filled in with any sort of environment like the single tile, double tile, corners etc? For example as to what I'm having problems with, this is the tileset for water and land what would stick out of it. It is created by following what most other tilesets do. I notice that I am missing some ways to make bends and there is no tileset for a single hole.

And this is what I mean with problems when creating tilesets in Tiled, as you can see there is no way to leave a single block of space when trying to put down a tile at the marked position, it autofills the tile below as ground even though a water tile would fit with no trouble.

Probably a very arbitrary question and I'm probably way overthinking this, but making tilesets seems to have very strict guidelines.