You'll find most Somber Ancient Dragon Smithing Stones in Elden Ring in areas accessed using the secret Haligtree Medallion. Though it is technically optional, it is definitely worth completing these areas if you have a Somber weapon that you wish to upgrade to max level.