A couple of things--there are differences in sand.
Quartz sand. This is inert, and won't impact your water chemistry. Comes in a variety of grain sizes, and is cheap.
Silica sand. Also inert, cheap, variety of grain sizes,usually smoother than quartz sand. Much maligned for releasing silicates and encouraging diatom blooms--this doesn't actually happen unless your pH drops below about 4.0. When this happens, diatoms will be the least of your concerns.
Aragonite sand. Not inert! This is the kind of sand most commonly used in SW and high pH cichlid tanks--it is coral bits, broken fine and worn smooth. It will raise your pH in many cases, and buffer the tank well. Sold under Southdown Playsand and Old Kastle.
Deeper substrates are fine, as long as you don't muck about in them or keep them turned over regularly. If you have digging fish, this may cause a problem. Planted tanks frequently have very deep substrates with a mix of sizes, and the plants benefit from the anaerobic areas, while roots moving about prevents anoxic areas. It's an either or--you have to keep it turned over, or never touch it. Most problems are the result of slacking in maintenance, or deciding to 'really clean' a previously undisturbed setup.
For cycling, if you currently have a UGF as your primary filter, the tank will completely recycle. If you have a HOB or canister filter running, mush of the bacteria bed will be within the filter rather than the substrate. There may be a small cycle--but you shoul dbe able to limit the negative effects by doing daily water changes (test to be certain this is needed--I replaced a 15 gallon tank with a 40, and didn't use any of the old gravel, just the filter and media. I never had a spike, but the tank was planted and understocked).
As for the comparison between a SW DSB and a FW sand substrate--keep in mind that one of the reasons the DSB works is because of the critters. There are not comparable creatures for a FW tank. Most FW macro invertebrates are 1) food items and 2) insect larvae. Not an easy population to maintain within an aquarium. Snails help, and many will dig in the substrate. Crayfish would also help, but can be destructive and predatory. FW crabs would also work, but most of them need access to the surface, and will nab fish is they can--not ideal inhabitants of the average aquarium. FW leeches would be good, but the 'yuck' factor probably excludes many of them, even those that do not suck human blood. And, unfortunately, many of the good FW macroinvertebrates are even pickier about water quality.