Revisiting Fundamentals of NMR Relaxation in Bulk and Confined Fluids