Floor tile care is relatively simple to maintain. Just a few drops of liquid soap in a hot bucket of water is generally all that is needed. There are some ph balanced tile specific cleaning products that are grout friendly. Harsh detergents are not needed and may cause damage to your grout.
Showers or areas where there is moisture and water are prone to that red mildew stuff that usually starts on the shower floor. Leaving the shower door open after use can help with ventillation which can slow the process. Wiping the walls and door will also help and cut down on possible water spots especially. Trying using a nylon brush with soap and water to remove any build up. Tip: seal your grout and tile in these areas which will make cleaning easier. Tile can be sealed which is similiar to waxing your car. It just keeps stuff from sticking to it.
Natural Stone needs to be protected from day one. In fact, all of the stone fabricators that I know apply a coat of tile and grout sealer after fabrication and before it is installed. Acidic liquids like orange juice can etch a polished surface. Keep your stone sealed with a high quality "impregnator" that will soak into the stone and keep liquids from setting in.
Grout care seems to be one of most common issues which really doesn't have to be. I have found that a high quality sealer can make cleaning grout a fairly easy task. If your grout has been neglected and needs a deep cleaning, read How To Clean Grout and then seal afterwards.
Here's how I would rank the above in order of least to most maintenance required: Floor tile (ceramic-porcelain), natural stone (granite,marble,travertine,slate,limestone), grout (saned-unsanded). Plan on using a material that is best suited for your maintenance allowance.