Grob is the starter in Canada. That said, a Texan II or Super Tucano (said to be on the way) would be a better start for DCS, because they can be armed.
edit: A quick google search suggests the USAF uses entry-level Cirrus and Diamond as the initial aircraft.