I do own this antenna and it sits with all the other antennas that I have collected in large Ziploc bags for the last 50 + years.
Anytime you have such wide coverage on an antenna, some part of that range will suffer, this antenna actually benefits those who are looking for reception help with VHF low-band. It also works very well on VHF high band, fully collapsed it is decent on UHF, T band and 7-8-900 MHz.
The hinge is a little hinky but it allows you to fold the antenna over collapsed to the side of your portable. There have also been reports of the BNC connection being very tight.
As far as being a good match for the sds100 I don't know? It is telescoping so as to be tunable. It is a little unwieldy. I couldn't tell you if the sma version will make a good connection with the sds100 mount. You would have to use the BNC version with the BNC adapter that comes with the radio and that is going to put great stress on the SDS 100 and you are one drop away from breaking the radio. There is an after-market BNC adapter that has a lower profile and wider base that is safer.
We have discussed the REM 842s in the past so I'm not going to talk about that here. There are also many many other options including Diamond offerings like the RH77CA. Anything will work better than the crap stock antenna that comes with the radio but there are still those who swear by the stock antenna but I wouldn't know why.
If you want superior reception you need to get a rooftop with low loss coax which I see you plan to do. Until then you can get a low profile base antenna like a ground plane or mini discone and mount it on a floor lamp or hat rack or tripod that you can position for the best reception. You can also mount it in the attic or suspend it from the ceiling.
As far as portable application, you have so many choices and as I say anything will work better than what you have now, some of the offerings, not much better. Since you focus on the VHF High area, in a mobile application you are going to want an external antenna on the car as VHF High will be compromised inside a car.
Whatever you do for your go to daily antenna for portable use for the sds100 I advise you to stick to the KISS principal.
You have so much to choose from but... That's a good problem to have.