For NTSC: I've used one of the Sony devices listed in
this MacWorld article from the era, primarily with Mac OS X (10.5, Final Cut Express, also iMovie), but "DV" is pretty standardized so there's no reason they won't work with iMovie or Final Cut 2/3 on OS 9 on a G4 Cube.
The Formac Studio DV/TV may be the "best" option, certainly the aspect of FM tuning on a modern Mac is pretty interesting. As mentioned, the TV tuner may be no good, unless they later updated it to be an ATSC and/or DVB-T tuner that puts HDV in, although you'd probably need OS X and a newer copy of iMovie or Final Cut (like, from 2004 or later) to capture HDV.
There also appears to be a Formac Studio DV that only has the analog/DV conversion functions.
Another nice thing about many of these bridges is you can connect an analog TV and video deck to the output side (at least on the Sony) and "print" your video to tape, or use that as a preview monitor when you're editing, depending on what software you have.