Studies on certain aspects of strongly-correlated molecular states explored via suite of state-specific multi reference coupled cluster formalisms