Putin, it's more than reasonable to be against nuclear power but I think you may be off base with some of your understanding.
First, about the consumption of resources in a nuclear plant -
Obviously, the ideal is some mythical plant that runs on minute amounts of unobtainium . Unfortunately, we need to face the realities of living in an energy consuming society. The life cycle carbon emission of nuclear plants is comparable to the renewable and way way less than fossil fuel plants. Uranium consumption is an issue but not an insurmountable one. There is plenty of it for the time being as well as alternative fuels like thorium or reprocessed spent fuel. The mining practices of the uranium companies are the most revolting part of the industry. However, bad mining practices are not an intrinsic property of nuclear power and should be dealt with separately.
Regarding spent fuel -
There are many places to store spent fuel. Yucca mountain had many flaws to it but it is not the only option. Storing the fuel is an engineering problem, but not one that is insurmountable. The fuel will stay radioactive for many thousand years. However, if it appropriately disposed, it will not be released. Beyond the engineered barriers, actinides are very immobile so their transport to surface is on a scale of many half-lives. From the Oklo 'reactor', we have evidence of how spent fuel acts under the worst possible conditions (flowing water and no engineered barrier).
Transporting radioactive material has no adverse effect on the population it travels through so I do not consider an issue.
Regarding cost -
Yes, this is an issue. Unfortunately, the cheapest solutions are fossil fuel plants. If we want to get away from them, we need other options.