Sushi rice traditionally is short grain rice. It should be "new rice" or shinmai "新米", for the best rice. As for looks it should have a sheen but I don't think it should be transparent. When cooking sushi rice, you should wash it well. When washing, put the uncooked rice into a bowl with enough water to cover the rice. Then rub the wet grains together to wash them, this removes any dust or powder from the grains. Then rinse the rice out with fresh water and repeat, till the water is mostly clear.
Then strain the rice out in a colander or some other net or wire basket for at least 30 minutes to an hour, but it should not be soaking in water. You want it to rest and absorb the water, but not too much. Then cook according to your recipe, used bottled or spring water depending on your local water. I will pre soak for just another 10 minutes before cooking. In sushi restaurants they place the uncooked rice in a tightly woven netting. This is used to keep the rice from sticking to the pot while cooking, and to get the rice out all at once.
After the rice is cooked it's taken out and emptied into the traditional wooden (japanese cedar) bowl, hangiri. Where it is seasoned with rice vinegar/mirin/sugar mixture, stirred with a flat spatula (shamoji) and cooled with a fan (uchiwa) till just warm. Ok, now they still use the bowl and spatula, but they use an electric fan to cool the rice. It is then either put back into the rice cooker or it is placed in a wooden lidded tub to keep till it needs to be used.
The sushi rice should be sticky but not wet and it should have good texture, not soft or hard.
If rice is too wet:
*soaked too long or washed too much.
*too much water when cooking.
*wrong heat levels if cooking on stove, too low for too long.
*too much sushi rice seasoning if wet type. Helpful to use the wooden bowl as it absorbs excess water/moisture from rice.
Ingredients not sticking, will depend on the rice texture and stickiness. But sometimes it is also the wetness or slickness of the ingredients. Then it might also depend on what type of sushi you are preparing...rolls (maki), hand rolls (ice cream cone looking), or nigiri sushi. I would suggest that you use the first two if things are moving around too much, as they form a container for the ingredients. If doing nigiri or the little blocks of rice with ingredients on top then it might slip off.