I am hearing of two major Flavors of Adobe Campaign: Adobe Campaign Standard (ACS) and V6/V7.
1. Is there any other flavor?
2. How to choose between these two?
Appreciate your responses.
This depends on your needs and requirements. Here is a thread that explains some of the major differences between the different versions : What is Adobe Campaign and what are the differences between Adobe Campaign V6.11 and Adobe Campaign ... (v7 is like from this point of view).
Hope this helps,