You want the tray to keep the sump oil away from the crank. Some of those "stroker" trays are way too deep and won't even fit inside some oil pans.
If the tray is deeper in the oil pan than the oil level, it is not doing anything.
So the closer to the crank is generally better as long as the trays baffles can get rid of excess oil around the crank.