Solution: You need to delete the HUI Control section under Studio setup → Remote Devices. Then restart Cubase. I was able to use all functions on the Novation Launchkey 61 just fine after this including mapping, transport controls and everything else.
This is because Novation and other MIDI controllers with scripts in Cubase 12 are meant to be plug and play. The HUI legacy controls messes with them.