The main things to consider when bowling are:
- you want the ball to go in the direction you intend to
- after a collision:
- the pin must fall down (receive enough momentum/velocity)
- the trajectory of the ball should remain more or less the same
- there must be enough kinetic energy left to hit the other pins to the ground
As stated in one of the comments, a heavier ball is superiour on the first point, because a slight swing of the wrist has a larger influence on the lighter ball. Of course, the ball can't be that heavy that you struggle to swing your arm, because then, the accuracy gets worse instead of better.
On the next points, the heavier ball is always better. To put it clear: when a truck hits an apple, the apple will notice and significantly change velocity, while the truck is hardly influenced and has enough kinetic energy left to knock some other apples away.
In more accurate terms:
You give the ball some kinetic energy in order to roll towards the pins. A part of that kinetic energy is transferred to the pin it collides with in order to tip it over. The next graph depicts the percentage of the original kinetic energy that is not transferred to the pin and thus is still available to knock over other pins (assuming an elastic collision) (for the pin, a mass of 10 was assumed):
This maximizes for a ball with mass 0. A ball of weight 0, however has the clear disadvantage of not being able to knock anything down. After becoming zero when both ball and pin have the same weight (the pin gets the velocity of the ball and vice versa), it rises again with increasing ball-weight.
To prove this:
let's say, independent on the ball's weight, the kinetic energy it starts with is always $T$. Before the collision, the ball has a velocity $u_1$ and the pin velocity 0. The velocities after are $v_1$ and $v_2$.
$$\begin{aligned}T &= \frac{m_b u_1^2}{2} \\
\Rightarrow u_1 &= \sqrt{\frac{2T}{m_b}} \end{aligned}$$
For the velocity of the pin after the collision, this gives:
$$\begin{aligned}v_2 &= \frac{2 m_b }{m_b+m_p}u_1 \\
&= \frac{2 m_b }{m_b+m_p}\sqrt{\frac{2T}{m_b}} \\
& = \frac{2 \sqrt{m_b} }{m_b+m_p}\sqrt{2T} \end{aligned}$$
If the mass of the ball is small with respect to the mass of the pin, the velocity the pin has after the collision is far too low to fall over. This can be seen in the next graph as well. It depicts the velocity of the pin after the collision for a fixed T to start with.
Combine this with the graph above and it is clear that a heavier ball is better.
(ps: A mass lower than the mass of the pin is a bad idea for a different reason too: supposing an elastic head on collision, the ball will bounce backwards and won't hit any other pin)
Edit
For a fixed amount of kinetic energy to start with, it's not just the heavier the better: quite a lot of pins will not be knocked down by the ball itself, but by other pins. To maximize this, the velocity of the pins needs to be large. As the ball gets heavier, the starting-velocity will decrease and the velocity of the pin after the collision as well (see second graph). For that pin itself it won't matter that much: it will fall. With lower velocity, the probability of that pin knocking down a next pin, however, will be lower.