My machine has auto upper tension. It was set with certain parameters of fabric, pattern, etc. I can over ride the default settings, & I often do. I teach FMQ at the store so they know my opinions on tension.
I wouldn't choose a machine based on this option. I chose my machine for other reasons and auto tension is a standard feature, not an option.