This was my first real tutorial! It walks you through the process of authoring an Effect that can be used as a material in XSI ModTool, then exporting it and rendering it in an XNA app. Hosted on Gamedev.net.
http://www.gamedev.net/reference/programming/features/XSIinXNA/default.asp