It’s quite an open question. Most games I play are “one and done” even though I think most people go back to them. Even with replayability it doesn’t mean that you have to and I’m happy to leave things be once the story is over.
Mafia trilogy sticks to the story and will take a decent amount of hours.