A compact and cost-effective fiber-fed Fourier transform spectrometer for astronomical and laboratory applications: balancing spectral resolution, sensitivity, and stability