I love a stiff hit.
To me, the revos stiffness is magnified with a hard tip. It turns a stiff hit into a very stiff hit. I love it.
If you like a softer hit and don't break with it........you should be happy with a soft tip.
If you like a harder hit/feeling cue then you will be happier with a harder (medium hard to hard) tip.
Also, if you like breaking and playing with the same cue....well.....the hardest tip you can play with (not a break tip) will serve you well.
Fyi, a lot of people don't like hard playing tips. Most of them would love a harder tip if they had a stroke that allowed it.
All of the above is just my opinion based on what I like.
Rake