Oh yea, they are not the best for close up shots sometimes (depends on the tree).  I haven't tried anything else other than SpeedTree trees.  The Cinema Library trees are very nice, but I work mostly in games so I have only ever used the lower quality Games Library trees.  I have seen some impressive stuff come out of e-on Plant Factory too.
-Derek