The Roku Wikipedia article is a great resource for this.
The Roku Express+ (3710 or 3910) is the newest unit with composite support. The old Roku 1 and Roku 2 units also have composite support. You should be able to find them used for cheap; make sure they include the composite cable!