i think you are looking for highway terrain tyres if you want on road performance, low noise and high durability ... I dont think there will be any real advantage in putting all terrains .. they will be costlier, heavier(affect ride quality and fuel consumption) and wont offer any real advantage to your vehicle. Plus, will they be even available in the recommended size ? Remember if you have an AWD sportage/tuscon, you run the risk of destroying it if you are using non oem sizes ..
Just go for normal crossover tyres ..