i have been looking at houdini apprentice and the videos here at sidefx for a couple of days and i'm kind of amazed

my 3d needs are mainly in product visualization, medical vis and illustration (and to a certain degree archives) with modeling and rendering in modo. unfortunately (or fortunately - who knows

is houdini / mantra the right direction to look for these needs? is houdini / mantra generally used in these fields?
i'd be more than thankful for every answer.
david
edit:
will houdini work with sds or pixar sds made with modo?