To original topic, personally i love the game, started my probably 20th character today, Like many have said there isn't really a best weapon, what hasn't been said is that upgrading gear is often more important than upgrading stats, aside from vitality and endurance, which makes the game easier. And the heavier more tanky gear helps more on lower levels.
First time I played i hardly upgraded any weapons and that really made the game difficult, in addition i got cursed on depths, could not find my way back to undead burg and got lost on the swamp for 10 hours because **** blighttown... at least the first time playing.
As for the game itself, there are parts that are difficult, despite some people saying otherwise on the thread so there is a big chance that you won't finish the game unless you summon people to help. I'd like to recommend the game for everyone because of the atmosphere, exploration, design and involvement it requires from player to get most out of it, but the game is not for everyone. It requires patience, some parts are really difficult and feel unfair the first couple of times, mostly speaking of Anor Londo. Death can be difficult mechanic to accept but it's integral to the experience, world and story. Story is also very open for interpretation, there is hardly any exposition. There are about a dozen npc:s that all have a history that is hinted at, actually almost everything in the world is hinted at and given clues, so there is little "definitive" history. This has made wonders for the community.
For some people this has been just about the best game in recent years, part of them because of the alleged difficulty and challenge which you can find and make more if there is not enough, for others because of the atmosphere, open mythos and "bleak" world, because it can be very atmospheric. And for some, it's about the exploration and discovery. For what Dark souls does, it does it pretty damn well.
But it is not that for everyone. It definately has flaws and the nature of the game causes a barrier of entry, The opening areas are not visually the strongest the game has to offer, and the secretive nature of the game while one of its strongest points is also a major turn off for others. There are also some challenge spikes for first timers that can cause rage quitting.