You choose how much gain you would like with the understanding that it's a compromise. As you go up in antenna gain the antenna becomes more directional. That means that more gain equals less uniform pattern.
When talking about whip antennas on vehicle this generally means as gain increases the horizontal strengthens (think of it as "focusing" the energy like a lens focuses light) but the antenna radiates less energy vertically.
The baseline 1/4λ pattern is basically like a dome over you, no particular direction or elevation is significantly better than another. As gain of a whip increase the pattern flattens horizontally, as if you put a mirror over the antenna and the energy is focused towards the horizon.
However, the technical specifics aside, with your bracket location you are probably more concerned with finding one that works well without a good ground plane under it. Different length antennas work differently with respect to the what the radio sees electrically and how it reacts with its environment. Some need sheet metal under them to work well (1/4λ) but others don't to the same extent.
I would suggest you look for a 1/2λ (half wavelength) antenna. That will be most effective at radiating energy efficiently. It will have some stated gain but the actual value of it isn't important. The key is it doesn't need any sheet metal under it to work fine.