Pointy bullets are Spitzer rounds. They are more aerodynamic, lower drag, longer range.
Round end bullets have a larger surface area in the front, if hollow pointed they can create a bigger entrance wound.
You wont be shooting something 800 meters away with a traditional round, and at low muzzle velocities the spitzer round is less effective.
Which is why handguns for the most part use round bullets, as they have low velocities and they can expand and create a bigger entrance wound. An exception that comes to mind is the FN Five-seveN, a pistol that uses 5.7mm spitzer rounds that are made for penetrating body armor at a cost to raw stopping power, something traditional rounds are innefective doing.
Rifles mainly use spitzer rounds, as they need to hit targets at a range and need an aerodynamic shape to maintain supersonic velocities and accuracy.
However, spitzer rounds can be weighted to tumble on impact of flesh, causing greater cavitation and damage to internal organs. Most rounds above 5.56x45 NATO don't do this, they rely on their weight and speed to cause cavitation and hyrdrostatic shock.
If your unarmored, hollow point traditional rounds will do the job at close range. If armored, spitzer rounds pointy ends penetrate while round end traditional rounds are caught in the vest. However, a spitzer going straight thru you is generally less effective than a traditional going the same speed straight thru you. But what's the poing of having a powerful bullet if it wont actually penetrate the vest?
If I was going to encounter unarmored guerilla forces, I'd have a traditional pistol as backup. If facing armored terrorists, a Five seveN or HK mp7 would be a good choice for penetrating their body armor. reverse the two, and you're shooting small spitzer rounds when you could use bigger ones at the guerillas, and the terrorists vests would catch the traditional pistol rounds.
Also, I like guns.
Will anyone read this to the end?
TL;DR GUNS ARE DANGEROUS MKAY