Average Manatee
Diablo II's drop rate was tuned with the expectation that you would be playing online and trading with other players.
If you want to farm gear in a smooth upgrade ramp, you'll need to play a mod that supports that.
I highly highly recommend Median XL 1.F9, it addresses every problem you listed.
https://rpgcodex.net/forums/threads/diablo-2-just-turned-20.133758/#post-6785208
https://rpgcodex.net/forums/threads/diablo-2-just-turned-20.133758/page-2#post-6787655
Why is Median XL 1.F9 always mentioned on this forum? I checked moddb page of older median xl versions. Until Median XL Ultimative XII every version here belongs to BrotherLaz. Why not Median XL 2012 ?? Why specifically MEdian XL 1.F9? What happened after XL 1.F9?
https://forum.median-xl.com/viewtopic.php?f=4&t=34509&p=279536#p279536
watched more median xl videoes both old and new. I am not convinced in any way that this should be a better diablo 2 experience than vanilla or QOL modded vanilla like Path of Diablo and Diablo Project.
Watching youtube videos and playing something are two very different things. At the very highest level, gameplay is quite fast, but by then you are trained for it.
It's basically the same fucking thing. I don't care about speedclickin and shit, im not autist and i dont enjoy speedrunning. I enjoy feel, atmosphere, good design and that stuff.
Nothing beats vanilla D2 in terms of that, NOTHING, except improved vanilla mods like Path of Diablo. Literally nothing bad about the improvements they made, and the improvements should have been there at vanilla d2 release, it would have made everybody happy.
So yeah. Enjoy your pixel spam-click fest, I'll enjoy my Diablo 2 as it was supposed and imagined to be. Perfect.