Got talked into trying a dex/int build and use Moonlight Butterfly Horn. Noticing that the only req other than Int is starting Str of Pyro kind of sealed the deal there. Will level some boring Dex weapon for Artorius if I ever get there.
Top-tier sorcery works perfectly fine on Artorias. If you're just going to leave STR/DEX at minimum weapon reqs and pump INT, Soul Spears should handle him just fine. It's multi-element weapons that really get walled by his resists; any kind of offensive spell is still at least functional.
Moonlight Butterfly Horn is pretty cool. Not spectacular as far as numbers go but I use it as melee backup for mages just because it's one of the neatest looking weapons in the game (probably only Quelaag's Furysword tops it for aesthetics, that thing is so fucking metal). Obvious downside of course is no availability until Anor Londo. Mechanically you get to ignore physical stats totally because its damage is purely magic and scales solely from INT. Mostly this is a good thing, until you're fighting golems and suddenly you deal like no damage at all. Spears are generally low damage weapons, but it's still kind of a neat accessory for a caster to work through mooks at safeish range while conserving spells. It has niche uses, which is more than I can say for most boss weapons in DS1.
Moonlight Greatsword is pretty much the standard INT weapon, but that's an even later pickup, requires more investment in STR, is kinda heavy and chopping Seath's tail is pretty bitchy if you don't have helpers to distract him.
Maybe someday I'll respond to something that's not Soulspost