The ranges for usable tripods for the Red One range from a $1700 setup from Manfrotto to a $12,000 O'Connor setup and more. On the boards people suggest using the Manfrotto 526, the Miller Arrow 55, the O'Connor 1030 (all of which get more expensive as they are listed). The 526 supports 35lbs., the Miller 55 supports 50 lbs and the 1030 can support upwards to 40lbs. Now with the extra support in the weight capacity of the tripod, one gets better (smoother) panning and tilting.
Manfrotto 526
For myself, I'm in the resource constrained indie filmmaker set, and I use the Manfrotto 526, which I got used with a bag and a pair of legs for less than the cost of the head would be new. I have yet been able to use it in conjunction with a Red One, but for just a "stand up" tripod, I don't see why it would give me any issues. With the ability to handle 35lbs, I am constrained on what I can use on the rig, but with the ability to possibly offload a couple elements like batteries and drives, the 526 should be able to handle the load of a lightweight Red One rig.
When I do get around to testing it, I'll probably be using the Red One, production pack, battery, RAID drive, Nikon lenses, Red Rock Follow Focus and Mattebox. One thing that I will avoid doing is tilting and panning, and I wouldn't leave the rig unattended.