SQIII always felt a little short to me. SQV is probably my pick, but they're all great.

There's also some great Space Quest games made by the community, such as Space Quest 0, Space Quest 2 Remake, and Vohaul Strikes Back. Worth checking out for any SQ fan.