I do not know about other strategies but ask rich Martingale players if the novelty ever wore off.  The feeling of novelty depends on how often you play the same strategy and how much you expect from your bets.  Of course it may become really boring if you kept betting .01 Dollars every time hoping to double the amount.  Because who cares about .01 Dollars?  It is pretty much nothing.

If you bet 1 Dollar however, you may be happy about doubling it.  A free coffee is not something to be disappointed of.  If you double 10 Dollars, you win a cheap meal.  And so on.

But obviously, if you had billions and you were betting 1000 Dollars every hour, it may be fun at first but quickly become boring.  Not only does it mean nothing to you compared to the rest of your wealth, but you get used to it and desensitized.