Any Radeon card with ATi's "VersaVision" technology can do this, actually. It's an available feature on my 9800, handled through the ATi Displays preference pane. With a VESA mount and a Cinema Display, you could get some serious monitor rotating action going on.

The Contra games are tall ones, too.