it will be fine to see if someone activate his account. when not than automatically delete in admin
I do not think this is needed. Users may wind up finding the email later on in life and coming back to your site.
I think this is a good idea. Those who do not activate the account, then after certain defined period in admin panel, say 7 days, the account should be pruned/deleted just how the delete process works.