Mojave does not support Nvidia cards so yes switching to the AMD Vega is an option. As per Install macOS 10.14 Mojave on Mac Pro (Mid 2010) and Mac Pro (Mid 2012) - Apple Support
As some background the 'newest' official Mac compatible video cards for the MacPro5,1 were the Nvidia GTX-680 Mac Edition and the AMD Radeon HD 7950 Mac Edition. Both are long discontinued but might be found secondhand.
Whilst no newer Nvidia cards will work due to the lack of suitable drivers as per the above Apple article some newer AMD cards will. These newer cards however as standard will lack Mac firmware meaning they do not start functioning until the Mac operating system has finished loading. This means functions like FileVault, holding down the option key to select a boot drive, accessing the Recovery partition etc. do not work.
However some models could be 'flashed' ones self to have Mac firmware. This covers the 7970, the R9 280 and R9 280x. More recently a company called MacVidCards who have for several years 'flashed' Nvidia cards, they have recently announced they have now managed to flash the AMD RX 580 card. See - http://www.macvidcards.com/store/p116/Apple_EFI_AMD_RX580_4GB_and_8GB_Sapphire_Pulse_for_Mac_Pro_4%2C1%2F5%2C1.html
This whilst slower than a Vega would then have the Mac firmware to enable the above pre-boot features.
Having a flashed card is not compulsory, the lack of Mac firmware merely prevents the pre-boot options.