These ones you need to be cautious around are Valenciennea. These are the worst to try and keep, orange spots seem the best to try however you need a good 3” deep sand bed that’s mature (I’d say Atleast 2 years old if not 3-5).
I don’t recommend this genus as they eat much more out of the sandbed than what the other genera eat. Valenciennea really should be left for the mature and medium to large (4’+) tanks with thick sandbeds.
The easiest species to keep are Koumansetta hectori and Koumansetta rainfordi. These are much more relaxed when sandsifting but also will eat the algae that builds up on the sand so they don’t need as much of a mature sandbed as others may need. These are also relatively difficult to get feeding if you don’t already have it eating however I found mine to eat quite fast once he was in the tank with other fish.
Signigobius biocellatus is a goby I wouldn’t recommend to beginners as they’re harder to care for than most other gobies.
Amblygobius species are also great for sandsifting and don’t decimate the sandbed unlike valenciennea. They’re slightly harder to find though.