Which Nikon adapter would work for my needs if I DON'T need autofocus?

Long story short I only need 1 lens to work and function a certain way. I do NOT need autofocus. But it's the new Sigma 14-24mm for Nikon that just came out a little while ago, not many people have it on their radar. I just need it to work on aperture priority mode and be able to bracket photos as well. But i shoot on manual focus at infinite. I'm wondering if only the more expensive adapters like the commlite will work with this function or if the cheaper 99 dollar ones will let me control aperture as well. I care about image quality but if the more expensive adapters are only that pricey because of autofocus I could care less. Any info would be appreciated, thanks!