I'll play the other side of the card, i guess, with the 'who cares?' perspective.
If it's *almost* automatic (and it's like 99.6% successful over the past couple years), why bother with it? Slows things down, another chance for players to get injured or concussed, etc. Players are usually shown to be half-assing it on this play anyway, because they all know it's going to be good. And then you get freak injuries like Gronkowski breaking his arm and missing half a season while blocking on an extra point attempt.
We COULD go towards trying to make it harder, but why not go the other way? Make the TD worth 7 points. If you want to go for a 2-point conversion instead, you get 6 points plus the opportunity for 2 more. So basically exactly like today, just don't waste everyone's time with the automatic kick.
Been hearing too many crazy things about making it a 40 yard attempt (or more), making the points variable based on distance, etc. Either leave it alone, or get rid of it and make it *officially* automatic. Really no degree of difficulty with FGs of less than 40 yards outside of extreme weather anymore, so you'd REALLY have to push it back to make it any challenge, and then at that point, just going to get a lot more 2 point conversion attempts if it's anything other than perfect weather or a dome. Since the rule change will mean they don't kick it a ton anyway, why bother tweaking the kicking rules? just kill it.
But gotta leave the end result of a regular TD (with successful XP or automatic point) 7, because the 7 points vs 3 for a FG is what makes the scoring really interesting, creates exciting drives at the end, and affects gambling as well. Having a TD exactly equal to 2 FGs doesn't seem right, it's the 1 extra point for a TD (or 2 in a desperation situation) that drives a lot of decision making in the game.