To be blunt about it you use Cat 2/3 HPs when you are told to.
You will be told to use them when LVPs are in force.
LVPs will be in force when the airport decides to put them in force - but effectively when the weather deteriorates to Cat 1 Minima or less (circa 200'/600m).