There is a simpler answer.
If you need to fit a new transponder go for Mode S to avoid having to buy another in a few years time, they are gradually becoming required in more places.
If you already have Mode C dont bother upgrading until you actually need it because they are getting cheaper.