The spiking neural networks (SNN) which are inspired by the human brain offers wider scope for application in the growth of neuromorphic computing systems due to their brain level computational capabilities, reduced power consumption, minimal data movement cost, and among other advantages. Spike-based neurons and synapses are the essential building blocks of SNN, and their efficient implementation is vital to its performance enhancement. In this regard, the design and implementation of spiking neurons have been the major focus among the researchers. In this paper, functioning of different leaky integrate fire (LIF)-based spiking neuron circuits like frequency adaptable CMOS-based LIF, resistor-capacitor-based (RC) LIF, and volatile memristor-based LIF are subjected to comparison. The work mainly focuses on revealing analysis of spike duration and amplitude, number of spikes produced during excitation period, threshold operation, field of application, and various other significant parameters of aforementioned neuron circuits. Extensive simulations of these circuits are carried out utilizing the Cadence Virtuoso simulation environment in order to validate their behavior. Further, a brief comparative analysis is executed considering into account the attributes like circuit complexity, supply voltage, firing rate, membrane capacitance, nature of input/output, refractory mechanism, and energy consumption per spike. This work seeks to assist researchers in selecting an appropriate LIF model to efficiently construct memristors and/or non-memristors based SNN for certain application.