Pile foundations are the preferred solution for transferring both axial, lateral loads and moments when upper soil layers lack the necessary strength and stiffness to support a structure adequately, making them optimal in such conditions for bearing heavy loads than shallow foundations. Despite significant advancements in scientific pile design methods, estimating axial capacity still heavily relies on empirical correlations based on the SPT-N values. The effectiveness of many design methods based on SPT-N values can be compromised by variations in in-situ soil conditions. This paper addresses the use of SPT-N values for estimating pile capacity and examines the variability in estimation of axial load capacities of piles at site by different Methods, with a primary focus on Marine and Alluvial soils. Marine soil profile data were obtained from coastal Andhra region (Kakinada and Bheemavaram), while Alluvial soil data were collected from Assam. Bheemavaram comprises of two sites with a total of twelve boreholes, whereas Kakinada has one site with five boreholes. The Assam site is characterized by eleven boreholes. Axial pile load capacities, relying on SPT-N values derived from multiple boreholes at each site, were estimated using three methodologies, viz., the IS-Code, the Effective Stress method, and Empirical Correlations. Total pile, ultimate shaft, and base capacities, as well as safe total, shaft and base capacities, were evaluated for pile lengths of 15, 18, 20, and 25 m utilizing the aforementioned methods and were analyzed. The mean, standard deviation, and ratios of pile load capacities at each site were determined and analyzed. Based on the analysis, for marine soils, the Effective Stress analysis method showcased the highest pile capacities, with the IS-Code and empirical approaches yielding comparable yet lower values. Conversely, in the case of alluvial soils, the IS-Code method produced the highest capacity, while the Effective Stress method resulted in comparatively lower values. The investigation has shown distinctive soil strata characteristics in alluvial regions, featuring a mixed stratum with cohesive soil at the surface to a specified depth, transitioning into cohesion-less soil below. These results hold significant implications for engineers, guiding them to choose appropriate methods based on soil types, aligning with specific structural requirements.