I don't support war or general killing of people by people. As such, I find the very existence of guns that are designed to kill as many people as possible as quickly as possible pretty terrible. Though, I can understand the "collectors" appeal of these sorts of guns. If you just like shooting them at paper targets in a safe area, or appreciate their aesthetics, I have no problems with that.
Sporting guns... rifles used for hunting and the like, I'm fine with. If you want to kill a deer or something and eat it, go nuts. (I personally don't care for the idea of hunting for a trophy, though). If you're in the wilderness a lot and want some means of defending yourself against a bear or a cougar, I see nothing wrong with carrying a gun for that purpose.
Hand guns... I suppose if you think they will help you defend yourself, I don't really mind. I don't think a gun as self defence is necessarily a great idea. But, I'm willing to be flexible here. And, again, I can understand the hobbyist appeal.
I don't really care about guns myself. I don't hunt at all, and it would take very, very extreme circumstances for me to even consider turning a gun on a living creature, let alone a human. But, I don't think responsible, well-adjusted, mentally sound people should be denied them. Though, I think gun ownership shouldn't be a right. I think it should be HEAVILY regulated. It should be earned. I think you should have to prove yourself extremely competent in terms of safety, judgement, ethics, and mental stability. I don't think that system exists in North America.
I live in Canada. I actually have a firearms license that enables me to buy rifles or shotguns. You know what it took to get that license? Maybe 100 bucks total, and a half day course. I now have a vague understanding of how to handle a gun. I've shot a pistol and a rifle on one occasion in my life (completely separate from the course). I don't think I'm remotely qualified to own a gun. And yet, legally, I can. I think that process was frighteningly easy, considering I can now legally own something that can easily kill loads of people.