Hello JRM,
To my mind, if the memory error happens once a year - that's not really a big problem (even if it is not "corrected"). But if errors are happening very frequently, then ECC is just an indication that there's something wrong with the hardware.
As for the GPU choice in general, Quadro cards are considered to be more stable for constant processing load compared to gamer class cards. But if you are not running the processing 24/7, then most likely GeForce and Titan cards would be also fine.