In the mountainbike world (where they really care about suspension) things are mostly air these days. Air forks/shocks are more easily adjustable to accommodate a wider variety of riders, and the way they ramp up helps prevent bottom out on drops and big hits. Even the downhill/freeride world has mostly moved to air, though you'll still find people there who love the linear spring rate of coils. Generally air springs have a maximum pressure that limits total system weight, so very heavy riders often end up on coils. I'd guess thats why motorcycles tend to be coil as well. Coils are cheaper to build too; you don't need all the seals, chambers and precision manufacturing of an air spring, you can just dump a giant steel spring and a bottom-out bumper in there and call it a day.
You're kinda focusing on the wrong thing though, air versus coil is just the spring. The major factor in suspension performance is the damper circuit, which is what prevents suspension bits from being just bouncy springs. Thats generally where your money is going and what you'll really notice on higher end suspension bits. Smoother damping, better adjustment, generally separate high and low speed compression/rebound damping...
Also (for forks) the rigidity of the chassis plays a major factor. Double crown forks are generally more rigid front to back, but that rule has been upended over the last decade as fork mfgs increase the stanchion diameter and everyone has gone to through axles. I see a lot of cheap double crown forks on moped style bikes that have really spindly stanchions and I've wondered how rigid they really are.
I would caution you against getting too hung up shopping bikes based on spec sheets. Its possible for a double crown coil fork to be excellent and also possible for a double crown coil fork to be hot garbage.