Everybody dives differently. I enjoy using both a tight, penetrating beam and a broad video light depending on what I'm looking at. Also keep in mind that just because a light is heavy, doesn't mean it's heavy *underwater*
As others have said, the virtues of the tight beam are they're able to illuminate things a little further away, backscatter less (illuminate suspended particulate that obscures what's behind it), and can be used to signal other people (and not signal people, conversely). Disadvantages are certainly less coverage. Video lights cover a broader area but fall off more quickly over distance due to their spread. They are also mostly useless for communicating and more irritating for fellow divers as they throw light indiscriminately.
I frequently have video and narrow lights with me on the same dive. Having them both in the same light is more convenient than having two, but you sacrifice the power of either for the cost of including the other, generally.
I agree the first light you should have is a tight, powerful beam. I find it useful in more general diving scenarios and because it does one thing well, you can dedicate more of your budget to maximize performance. Also keep in mind that most narrow beam lights also throw a broad cone of light around it and this can often be sufficient for identifying the next thing to point your light at.
In the end though, get as much light as you can afford and buy whatever makes you happy.