This study delves into the micro-occurrence states and enrichment mechanisms of residual oil, pivotal for advancing the production from tight sandstone reservoirs, particularly from the Chang 8 Member of the Upper Triassic Yanchang Formation, Ordos Basin. Through an analysis of 23 core samples, employing high-pressure mercury injection, field emission scanning electron microscopy, thin section, and X-ray diffraction techniques, distinct reservoir types were categorized. The utilization of environmental scanning electron microscope, multi-solvent continuous extraction, and an oil components separation system facilitated an intricate analysis of residual oil micro-occurrence states and their subsequent effects on porosity and permeability reduction across varying reservoir types. The findings accentuate the integral role of reservoir type in determining residual oil distribution within tight sandstone reservoirs. Favorable pore throat sorting and connectivity in specified reservoir types are identified as conducive to residual oil enrichment with a higher concentration of light components. In contrast, elevated carbonatite and clay content in other reservoir types leads to adsorption of heavy components, disrupting pore throat connectivity, and impeding crude oil filling. The varied interactions between oil and rock, oil–oil, and pore throat sealing significantly impact the distribution of oil components of residual oil, culminating in a notable reduction of porosity and permeability by 2.63% and 0.197 mD, with corresponding reduction rates of 27.19% and 46.69%, respectively. The insights derived from this study furnish a theoretical foundation for augmenting tight oil recovery and comprehending the enrichment mechanism of residual oil driven by the heterogeneity of tight sandstone reservoirs.