I've heard people saying that Claymore eventually surpasses the Black Knight Sword in damage output, but I'm at NG+ with 40 str and 32 dex, and BKS still does significantly more damage.
Weapon upgrade chart, for all the new players who have been asking how upgrades work (honestly, it is a bit confusing until you learn it and use it a lot) : r/darksouls