Transactional vs Transformational UX

Is it just me, or is the role of the UX designer something of a Jekyll and Hyde affair?