I'm not an expert but can give a few tips I've learned. I use two cameras - one I'm definitely more familiar with and its just a little cannon point and shoot, like your typical consumer camera. The other is a DSLR where you can change out lenses, everything is manual focus, settings etc, and i'm really just still learning on that one.
For nearly everything, a tripod or something to stabalize the camera on helps out like 300%.
White balance is a bear and varies camera by camera. I either use a flash or not. With a flash you can get more accurate colors, or if you have actinic supplements you can turn them off.
In situations where I go without a flash its usually to investigate something or snap a quick picture of a fish, their colors aren't too altered by the blueness of my T5s. Sometimes I will photoshop with the white balance to try to get the right color to come out if I'm trying to show someone something in particular going on in the tank and the flash shot didnt work out, but good practice is to let people know when you do that, or just to ask them to ignore a blue color (or pink if you use Vhos still)
Theres all too much photoshopping in a bad way in this hobby, but I do think it has some legitimate uses as well depending on what you're trying to show in your photos.
For things that are moving quick and you can't really get them clearly, try upping your ISO. The picture will come out more grainy but its taken with a quicker shudder speed and moving objects are easier to get a good basic picture of. For stationary things, a lower iso speed and patience will give a good picture.
Oh and hexedagain has some relaly really grreat pictures of his fish that I don't know how he takes them but I give him mad props for his photography skills
For all other things my solution is: make the husband do it
