Mass Effect, Elder Scrolls, Final Fantasy to name a few. What these titles all share is that no one I know plays them anymore even though they all started out great. As developers put more work into online/multiplayer content the original game suffers. Not only this but you don't get to be the hero anymore. Your just a soldier fighting with a bunch of other dudes. I have to give props to Destiny for realizing this and coming back to the hero saga despite being completely designed for multiplayer. Don't get me wrong a lot of these are quite enjoyable but they leave you wanting. The only form of progress you have is better stats and achievements for the bored.
More Details
animated commercial product video