Assuming otherwise equal hardware (screen type, scalers, etc.), the only difference is that the higher the dpi, the further back you'd have to sit to not see the pixel grid. But if you need to sit a certain distance from the monitor, then certain dpis may be more attractive to you (not just in terms of seeing the grid but in terms of, say, pdf text rendering).
Well, I don't know if a higher dpi inherently means greater backlight leak-thru (meaning lighter "blacks," or worse contrast).