A Tiburon with the V6 will be way under 40k CAD, but you can get much, much better performance cars for under 40k.
Dodge SRT-4 - base price well under $30,000
Subaru WRX (non-STi version) - $35,000 base price
Mazda RX-8 - high $30,000 base price
Mazda Miata - Base price under $30,000
Mini Cooper S Works Edition - About $40,000 (A regular S goes for a little over $30,000 base price)
Ford Mustang GT (2005 Model Year) - Low $30,000 base price
Acura RSX Type R - $33,000 base price
Absolutely no shortage of good performance cars for under $40,000 CAD bought new. And most of these cars listed have plenty of room for options before hitting the $40,000 mark.