The best farming spot found so far will see you going underground in a tough area
In the vicinity of near the Impassable Greatbridge Site of Grace is a fight between giant demon dogs. They'll start fighting the moment you walk up to them Elden Ring Runes, and from there you can just take a seat and relax. I recommend sitting on the rocks next to the wall with the damage, because you'll have a great view and will be safe from danger.