Any of the Tales games after Vesperia. Those kept me occupied for weeks on end with each installment. I'd also say Phantasy Star Universe, that one was pretty beast though I exploited my way through the endgame by circling and kiting enemies with a laser cannon.
