An apparatus comprises a processing device configured to classify an input/output pattern of a given storage object that is stored utilizing a first type of storage resources associated with a first storage tier in the clustered storage system, and to identify, for the classified input/output pattern, a performance difference between utilizing first and second types of storage resources associated with first and second storage tiers in the clustered storage system. The processing device is further configured to determine, based at least in part on the identified performance difference, whether to move the given storage object from the first type of storage resources associated with the first storage tier to the second type of storage resources associated with the second storage tier in the clustered storage system and to move, responsive to the determination, the given storage object to the second type of storage resources associated with the second storage tier.