What am i missing that will make a great detail game look very professional
Talent? No matter how many tools you have, they won't do the hard work for you. Getting a greate modeller is a good idea - but you have to learn how to model. Getting a good texture wobbler is fine, but you have to design the texture in the first place. :) People with talent can write very good games without any of those tools. They just help make certain tasks quicker. :)
+BlackD