Based on your setup you can use tiering or not. Since you stated that you want your database on SSD’s and your VMware on your 10k drives then you will not be using tiering. Without using data progression as well you will not be using tiering as the data will not move from tier1 to tier 3 storage.
As for your 10k drives if you set them to all tiers then your data is going to write to tier1 storage first and once that is full then it will start writing on tier 3 storage. If it was me then, I would set your 10k drives to tier 3 so that all writes will go to those drives.
Please let us know if you have any other questions.