this may add to the confusion, but allow me to try.
It really depends on what you are going to do with it. If you are ok with recoil on big caliber like 44mag etc, and only do target shooting, I don't think handgun compensator is necessary.
If you are sensitive to recoil, AND/OR you are going into competition in the divisions where the compensator allowed, you would want one because even with 9mm where the recoil is minimum, compensator will still help reduce it further, especially in competition, you will want every edge you can get.
my personal example, on my glock 30s, when I first ran full load 45acp, given the tiny gun, the recoil is a little bit much. so I did put a compensator on it which helped, but once I am get used to the recoil, AND I don't do competition, but just target shooting, I just take it off and haven't used it for a pretty long time. Similar for rifles, from small recoil 223/556 to big recoil 308 and bigger, compensator/muzzle brake will help reduce recoil which is useful to help you stay on target while doing rapid fire.