Chris Johnson has a nice overview of the various options you have to build applications in MOSS 2007 (better would be WSS v3). Great to see that the Smart Part is one of them .