Starcraft 64 may not quite live up to it's PC counterpart, but it still offers a solid play for any fan of the genre.
Some drawbacks to the transfer between platforms are noticeable. For example, there is no world editor and obviously no online play, this means that your stuck with the default maps, you cannot create your own nor edit the ones that already exist to include more minerals or alter the layout of the terrain. One of Starcraft's major draws was that it had superb online play, which downloadable maps and customizable gametypes. Of course all of that is missing from the N64 version which although expected, still is disappointing. Multiplayer does still exist via split screen, and although it is sometimes a bit laggy, the overall quality of multiplayer is quite good.
Graphics are of good quality, although not great. You can still easily tell between the units and the background, there is depth to the terrain and most of the doodads and tilesets are still intact. Although there are a few limitation for certain. Unit portraits are no longer animated, the water is stationary. It doesn't live up to the quality that Starcraft created, but it will more than suffice.
Sound is hurt though, mission briefings are all text based which is disappointing because that is how the high majority of the story was conveyed. The storyline just won't draw you in without the deep psionic voices of the Protoss or the rumbling voice of the Zerg Overmind to inform you of your next objective. If your getting this game for story, do yourself a favour and stick with the PC version. The music is largely intact, Sound clips for units are mostly there, but they lack the usually funny sound clips that are played if you repeatedly clicked on the same unit more times than would ever be necessary.
Starcraft 64 is a solid buy, and a bit of a rare gem nowadays, be sure to grab a copy if you run across it.