You cannot simply brush aside this issue. Even if we have 100% safe reactors, generating waste that is deadly in a thousand years is simply not a good idea, no paranoia involved.
Besides: nuclear had its chance - they blew it because of greed and sloppiness, the usual thing that happens when large organizations deal with complex issues. I am 100% sure that even with novel reactor designs the same "human factor" would generate accidents like we have seen with the old designs.