Kevin Seitzer, Bill Mueller are two examples off the top of my head that have good hit tools, but not much HR power. Wade boggs is another but that hit tool is otherworldly. You could throw Cirillo into that mix, but he had average HR power plus lots of gap power.
It can be done, but the hit tool needs to be really good and the defense can't be a liability.