If the bearings are in need of replacing it is well worth considering upgrading them. Other than that, the upgrade falls into an "Enthusiast" category, better than stock but needed. The easier casting is much more of an improvement in accuracy than distance which is over rated imo. I do not recommend Super Tuning on any rels other that one piece spool shaft reels which I believe covers the PQs but there may be versions with the other design.
A tighter tolerance bearing should not need any extra maintenance. In fact, I believe the looser tolerance bearing will wear faster due to those looser tolerances.