I used a Sti-Co antenna for several years, I had a little CUV that had like 3-4" of clearance to my garage door. Antenna held up fine and worked the same as any other 1/4 wave.
When you buy them they come long enough for like 130MHz or something, you have to cut it to the frequency you want. I think they had a cutting chart or you could use an antenna analyzer to get it exactly on frequency. They give you a little rubber end cap, the cap changes the frequency slightly so if you use an analyzer test it with the cap on. A little drop of silicone glue or hot melt will stick the cap on when you're done.
As far as the NMO mount, really any reasonably made one will work fine. There are specialty ones made for GHz+ frequencies, and even some with a larger center contact that they claim works better on low band, but I wouldn't worry about either of those types.
The only oddball thing I might consider would be a "fully enclosed" mount. Those are a little different with a connector on the mount and then a mating connector on the coax. The only thing the extra cost and complexity gets you is a little reduction in signal levels inside the vehicle, but it might be helpful in reducing interference to and from other in-vehicle electronics.