Yeah obviously more hits the better but like you said, depends on what type of hits they are. If they're only singles, meh. If they're HR's or doubles, different story. Someone like David Eckstein can hit .290-.300 but can be meh in a lot of other categories.
You can even see studs, where they vary from season to season. One season they could .300 and then the next .260ish. Look at Jose Bautista as an example. In the end, he still provided excellent OBP skills, power numbers, so his batting average whether he hit .300 or .250 didn't make such a huge difference at the end of the day.