I'm surprised to not see Flare RPG mentioned. It's nothing groundbreaking on its own, but it's actually got two nicely fleshed out campaigns, and tooling for people to make new ones. It's a nice, fun, FOSS single-player RPG, and it's great if you want that old fashioned Diablo feel.
Another vote for Endless Sky here as well, it's just excellent, and surprisingly expansive.