This paper presents a comprehensive review of mixed convective heat transfer phenomena involving fluids with varying Prandtl numbers, specifically focusing on their behavior in different geometries and orientations. This study systematically explores heat transfer characteristics for fluids with low, medium, and high Prandtl numbers across a range of tube geometries, including circular, rectangular, triangular, and elliptical cross-sections, and examines their effects in both horizontal and vertical tube orientations. By consolidating existing research findings and analyzing various experimental and numerical studies, this review elucidates the complex interactions between fluid properties, tube geometry, and flow orientation that influence mixed convection heat transfer. Key insights are provided into the mechanisms driving heat transfer enhancements or degradations in different scenarios. In view of the findings from this paper, more than 84% of studies were conducted in a horizontal orientation and circular cross-section with a tendency to use medium-to-high Prandtl numbers as the working fluid for the past 10 years. This paper also identifies critical gaps in current knowledge and suggests future research directions to advance the understanding and application of mixed convective heat transfer in diverse engineering systems. Furthermore, apart from having different geometries applied in industrial applications, there is still room for improvement through the addition of passive methods to the heat transfer system, including helical coils, corrugations, swirl generators, and ribs. Overall, from the literature review, it is found that there are few relevant numerical simulations and experimental studies concentrating on middle Prandtl number fluids. Hence, it is recommended to perform more research on medium Prandtl number fluids that can be used as energy storage systems (ESS) in concentrating solar power plants, nuclear reactors, and geothermal systems.