I don't have D2R on PC but did play the old D2 on PC and now have Xbox console D2R.
Skills where you need to hit/target the monster are much easier on console (eg. Charge on paladin, frenzy on barb, most arrow skills for Amazon, etc.) You just map the skills to one controller button and pressing it immediately uses it. Makes it more like an action game or more modern ARPGs.
But--this is a huge negative--skills where you don't always want to target the monster (eg. Multishot on Amazon, shift-click for paladin zeal, whirlwind on barbarian, etc) are impossible to execute properly on controller. For example, by clicking on empty space on PC (ie. Not target a monster) you can control how wide/pattern of multishot arrows of Amazon but it's hard to do that on console controllers. The controller automatically targets nearest monster so it's impossible to target beyond the monster (like a WW barbarian.)
SHIFT-click doesn't exist in controller so advanced users of that (usually useful for melee or special builds) can't use it.
Manipulating inventory is also difficult with controller. You literally have to drag the cursor to move potions around, etc.
Because the controller targets nearest item (although there is some priority) picking up items from the ground is iffy sometimes.