It's all personal preference so you will probably get as many different answers as you do replies.
Obviously, metal spikes are king. If you've never worn them it's hard to appreciate how much better they are. But, there's no denying that they are hard on greens and even harder on the carpet at the clubhouse. I sure do miss that "click...click...click... when you would walk across the cart path.
I stick with FJ's primarily. Not because I think they are the best shoe it's just that they fit my foot better than most others and they last a long time for me.
I've tried about every soft spike there is and I still prefer the "cyclone" that comes in the Dry Joys Tour. I don't care for the "Stinger" spikes that FJ offers in a bunch of their shoes. I tend to replace my soft spikes pretty regularly since I am a little OCD and the golf shop here always stocks the FJ Cyclone spikes so it makes it easy for me to keep fresh ones in my shoes.
The FJ Superlights come with a very thin sole if that is what you are looking for. I prefer a traditional looking shoe but several of the Tech players wear the Superlights and they really like them.
Anyway...it's all subjective and there will probably be several people that have different opinions.
Happy hunting.