Better SP provides all-around improvements to single-player like faster walking and running, increased inventory and stash size, with a slew of other features.
D2R, specifically, increases the likelihood of getting good loot from tougher enemies, while Guaranteed Drop will make every single enemy drop an item. Mods like D2R Drop mod and Guaranteed Drop mod both let players mess around with drop rates of items.
