As it:
Works in Safe Mode
Works when UAC is disabled
Works on another machine (Linux)
It suggests that the Hardware is fine and it's definitely a software permissions/access-level issue in normal Windows mode.
Open PowerShell as Admin and type:
Get-WmiObject Win32_CDROMDrive
What do you find?
Right-click Roxio Creator NXT9 shortcut → Run as Administrator
See if the drive appears now.
Try with a different DVD burning application to check the issue.