Based on your described wants, you're definitely looking for a full Windows 8 Pro convertible.
The bad news is, they're out of your budget, running ~$1,000.00.
But the good news is if you can expand your budget now or by waiting and saving, there are, or will be, some very good options.
Windows Surface Pro will be coming out soon (
Preview Article).
The
Acer Iconia W700 has received good reviews, but is sinfully ugly IMO.
The
Lenovo IdeaPad Yoga has also received good reviews, though the keyboard is non-detachable (and I'm not sure of availability in Canada).
Then there's the Samsung ATIV Smart PC. The
700T Pro version would likely be the one I would buy today if I were in the market, as it has top specs and comes with a great Wacom Stylus. There's also the
500T version, which doesn't have the same top of the line (for this generation) specs (e.g. no HD resolution display), but it's the one Windows 8 Pro tablet that you can get that is LTE-enabled,
through Rogers, and comes in at a competitive price with the Windows RT tablets.