The biggest benefit is the self basting the meat receives as it rotates, but on the stationary ones, you can place them over each other and get a similar effect.
Another Benefit to the non Rotisserie ones is that they tend to have more capacity.
Most of it comes down to personal preference and what you can afford.
Spend some time getting to know them all before you purchase or build one.