Considering someone made a harpoon gun with a custom mesh last year, yes you can make a new gun w/e you want it to be with a custom projectile. But before you build a spaceship, maybe you might want to start with building a box?
Play with the devkit, duplicate the rocket launcher, fiddle with it, crash the dev kit, and start with a fresh rocket launcher all over again till you figure it out.