It makes me sad that after 10 (!!) years of having 3D in Photoshop, I can’t think of a single time I’ve created good-looking text in it, much less anything else 3D of value. Given that PS includes a whole 3D engine, I hope that someday it’ll include easy ways to make attractive text.
In the meantime, amidst sometimes literally cheesy results, Art Text 3 ($29.99) produces some rather impressive pieces. Maybe Adobe could just license & bundle it as a plug-in. Hmm… (No, I don’t know anything you don’t know.)