Advantages and limitations of transition voltage spectroscopy: a theoretical analysis