The latest and prettiest is the Frontier Alphatrack (pictured), a $199 USB box containing all the essential bits of a recording console, but much, much smaller. There's a full-length motorised fader, a few knobs, proper play / stop / record transport controls, and a ribbon controller for scrubbing back and forth through tracks. It should work straight out of the box with Pro Tools, Sonar, Cubase and Reason. Similar in concept, but simpler in design and without the knobs or the handy LCD display, is the Presonus Faderport.
Mixing with a long motorised fader and real transport controls is certainly more fun than clicking at an icon with a mouse (or pushing the space bar, which starts and stops most software sequencers). But something has been lost along the way. In the late '70s, when 24-track recording was possible but there was no reliable way to automate mixing, mixing records was a live performance, with the producer, the engineer and half the band called in to push faders up and down as the track was bounced to the master tape. Somehow this little blue box isn't quite the same.