There is no substitute for just shooting the darn things from field positions ... tables are fine, but they don't tell you how you will hang onto the gun in recoil.
Lighter bullets moving faster will generally flatten out the trajectory and, all other things being equal, extend your effective range. What might be 150 yards with a 325 gr bullet might become 200 yards with a 260 gr bullet, for instance ... I haven't personally found that to be the case. I zero my hunting handguns at 100 yards and am competent with them to 150 yards, regardless of bullet weight. Lighter bullets may shoot flatter past that range, but it makes no difference to me as I won't generally hunt with a handgun past that range. I like to put my hunting bullets exactly where I intended and not speculate. Others can shoot past 150 without speculating, but not me ...