I think the answer, like with almost every other self-defense subject, is "It Depends". If time and distance allow, sights will always be a better choice. In situations requiring immediate close-range fire, point-shooting is best.
When I began my MMA career in the early 2000's, every fight magazine featured tons of "grappling vs. striking" articles. Striking styles were virtually useless on the ground, but grappling didn't work well against multiple attackers or when the environment prevented takedowns.
In both shooting and fighting, the professionals figured out real quick that you need to know both styles. For both of these situations (grappling vs. striking & point-shooting vs. sights), I can't tell you which style is "better". What I can tell you with absolute certainty is that neither of them work perfectly in every situation. There's nothing wrong with preferring one style over the other, but you need to be familiar/proficient with both.