GoodOldJack: Are any of those games completable in a weekend if you play enough of it. I just dont want to get into something that will take more than 40 hours of time mostly.

Can anyone recommend which one?

Starmaker: Humans rule, other races drool

Starmaker: Champions of Krynn is short, I can finish it in a literal sitting, between bathroom breaks. It's also rather sparse and linear. Death Knights is the best of the Krynn games (but you're strongly advised to have played Champions) so if you know what you're doing (recommended party: 3 knights, 1 wizard of each legal color, 1 cleric*), you can finish both in a weekend.

I'd recommend Gateway. It's not as pretty as DKK in the pixel art department, but it is a complete standalone story and it has more variety, event- and location-wise. If I may make a RL comparison I am utterly unqualified to make, DKK is a walk through a historical city quarter and Gateway is Disneyland.

edit edit: both these games are easy, and DKK is somewhat unfair (but still easy). The remaining "best Gold Box game" is Curse of Azure Bonds. It's less fancy, it has a crappier interface, almost no overworld, but it's hardcore. Theoretically, it can be won in a weekend; in practice, I got screwed and restarted missions a lot, incrementally, to figure out the best approach. (40 hours might be enough, though.) So, if a game you end up choosing bores you with easy combat, try Azure.

edit x3: if you're familiar with the tabletop AD&D metagame, recall what you know and do the opposite. Humans rule, other races drool. Multiclassing is a trap.

(I also don't advise hex editing beyond maybe setting the strength of your female warrior-types, if any, to 18-00; with this one exception, the in-built editor is quite enough to max out your stats within reasonable limits.)