Why with VMS 9? BluffTitler creates files that are VMS version independant. You can import BluffTitler created files in any NLE just fine.
That said .. I have VMSP 8 (and recently added Vegas Pro 8) and I also have BluffTitler. I love BluffTitler. I don't have much experience with any other titler programs .. but BT does a great job for a reasonable amount of money (updates are *always* free)
You can output BT with an alpha channel so that it will overlay an existing video track, or create your own complete video within BT using either supplied effects or your own still photos for backgrounds ... or you can even output still frames from BT if needed.
BT uses your existing Windows fonts. It comes with hundreds of sample effects that can easily be modified for your own needs ... or you can create something from scratch.