Metal Gear Solid 3: Subsistence, the mainline games as a whole left a huge impression on me, but 3 is the best of the bunch I'd say
Grand Theft Auto: Vice City and Xenoblade Chronicles are right close behind though [plus Vice City is for sure my most played single player game ever]