When F is some distance away from the COM, it is intuitive that the cylindrical object tends to rotate about its axis. However, in the real-world, the cylinder rolls on the surface under F, which means there is another force in the same direction of F that forces the center of the cylinder to move. That's f.