From your list:
Modo - Never Used it (Made from people who used to work for NewTek (Lightwave) so there are some interface similarities.
Silo 2 - Fantastic, brilliant interface and workflow. Bear in mind this is a modeller (with a UVMapper and Sculpter) bear in mind that you can't texture, animate or render in it. For modelling I recommend.
Hexagon 2.5 - it's a useable tool and can be groovy - before version 2.5 I suffered from a number of bugs and came to dislike its workflow. In Vista I've been tryng to use it as a UVMapper, just my luck, it crashes when I try to UVmap the model I want.
Milkshape3D is a Modeller/Animator, good for gaming export, bad for modelling IMO - animation is easy as pie in it and it's exports are stable.
Cinema 4D - My ultimate dream, but the latest version is too expensive and the demo seems to crash for me in Vista...which is odd because C4D has a history of being really stable...not great for game export though - or at least I had trouble back in version 6, which is quite old now.
Lightray - Never heard of it
But what do I recommend? I recommend learning and playing with demos so you can find out which is best for you...but I can always post my 'ideal' toolset if it helps.
Modelling: Silo 2
UVMapping: 3D-Coat
Painting/Sculpting: Zbrush 3 (but 3D-coat can do this too, Zbrush is just better
)
Animation for games: Milkshape 3D
Rendering/Animation: Cinema 4D or Lightwave 3D
If you're on a tight budget, tools I'd recommend are (given you're looking at C4D, I doubt you're on a tight budget)
Modelling: Wings3D(Free)
UVMapping: Lithunwrap(Free)
Painting: Paint.NET or GIMP (Free)
Animation: Milkshape 3D ($20)
Rendering/Animation: Blender (Free) or Anim8or (Free)
What I currently own (not the best setup):
Modelling: Hexagon 2
UVMapping: Lithunwrap
Painting: Paint.NET
Animation: None
Rendering: Carrara 5 Pro
"Experience never provides its judgments with true or strict universality; but only (through induction) with assumed and comparative universality." - Immanuel Kant