Try not to over think it. Sand is easy and simple. I dont maintain mine at all. The rays keep it stirred up so I don't have to vacuum either thanks to a solid turn over rate (hammerhead pump). My best advice is to find a sand you are happy with that is safe, rinse it really really well before putting it in a tank and enjoy. All my tanks have sand except for pup tanks and QT. Those are bare bottom. I'm on mobile at the moment so no pics sorry. Avoid play sand. Pool filter sand, the Lapis Lustre I mentioned (a media blasting sand) as well as a few others are cheap and good options. Or you can go the spendy name brand option. To each their own. Moderation is key so try not to have a really deep sand bed and you won't have to worry about gas pockets or anything.
Vacuuming sand for people who like to is easy. Just wave it over the surface or dig in. Either way.