Absolutely not. The package from rpmfusion handles cuda quite nicely and I have never needed any other source for the cuda drivers. In fact, as I understand it, the rpmfusion cuda driver is built from the official nvidia packages and is kept up to date.
There have been several posts about conflicting cuda drivers and the fix, IIRC, has always been to remove all other packages and disable those repos while only using the one from rpmfusion.
That linked how-to is sadly out of date and has not been updated for quite some time.