Well, I’m not a big RPG player myself, but I’ve heard the “Fallout” games are highly recommended, and Fallout 1 and 2 have been ported to the Mac. (Fallout 3 isn’t, yet, but as others said, in a desperate bind, you could always try to getting running under Windows)
Heck, Apple’s got a good list of titles, and Macgamefiles has a number of demos, and a lotta shareware.
There are a few good Mac abandonware sites, but since you’ve got a new Macbook, IIRC, you’d need to get an emulator to run an OS 9 (or earlier) system for them. Which is doable—I’ve used one called Basilisk II, on occasion, with good results—but you’d probably need a ROM image and a copy of the old operating system to do it. Depending on your computer savvy, what kind of Mac hardware/software you have lying around already, and what you can scrounge up online, this might not be a problem, or it may make it more trouble than it’s worth.
Anyway, back to the subject—Spaceward Ho! is an old favorite, and still available in a modern version, though it’s a tad pricey (relatively speaking, anyway). DEFCON is another fond time vampire, though it might not be your cup of tea.
The Civilization games—it’s up to Civ IV now—are available for the Mac, with several expansion packs, and a great deal of “mod” potential, as I understand. Be warned, however, that they’re known to be incredibly addictive…I remember reading about talk show episodes almost 20 years ago featuring people who’d gotten addicted to Civilization 1.