Nero 9 supports lightscribe and labelflash and uses Gracenote metadata service. I read the
manual for "Nero Burning ROM" section, and it did not explicitly say that it will print song names on the label, but it did talk about label printing, so perhaps you can configure what gets printed. Lightscribe is cooool. The CD-R is white and the printer prints right onto the disk, no labels.
Is it possible to repair your Roxio? You seem happy with it. Do you have the original install disk with the label writing features? Just use Revo Uninstall to remove the old Roxio, and reinstall it fresh. If it is choking due to incompatibility with Windows7, then you can adjust compatibility mode for the operating system that is compatible. Find compatibility mode settings by right-clicking on the icon for the program choose Properties, then Compatibility tab. Run it as XP or 95 or whatever it needs.
I have a very old Roxio installed on my XP machine, I may be able to find the disk if it is the same version you need. I have never used the label printing so I don't know if mine importa metadata from net. Let me know the version number if you can get it from the About... section, usually under help menu.