Interactions among motivation, cognitive functioning, and affect shape much of the diversity in human behavior. This study aims to synthesize the literature on these interactions through a narrative review and highlights how a particular class of motivations leads to paradoxical effects. The literature review was conducted by following a rigorous search protocol to identify and filter the research on the topic. A synthesis of the pertinent research suggests that motivation, cognitive functioning, and affect interact cyclically to give rise to behavioral diversity. More importantly, affective and motivational influences lead to flexibility in cognitive functioning. This flexibility in information search and processing gives rise to paradoxical effects in the case of a class of motivations called, desires. Regulation of affect helps tone down these paradoxical effects. To conclude, few implications to theory and practice are discussed. © 2019, Global Institute of Flexible Systems Management.