That is a tall order - a car with a manual, fun to drive, AWD, and ground clearance. The more ground clearance you have, the worse the handling - matter of physics. Stickshift is rapidly falling out of favor - Subaru it used to be a mainstay of the brand and now only the Crosstrek and WRX still has it. Worse, the WRX used to be a hatchback and now it is a sedan in the recent times.
Still, a used Subaru WRX might fit the bill. I say used because the redesign made it a sedan in 2015. If you want the hatch you probably have to go back to 2014. They are reliable, have a lot of power (about 300 hp), have AWD, and have reasonable clearance. here is one near me for a reasonable price and well equiped with only 20,000 miles on it:
If you want a new car, then the Subaru Crosstrek ticks all of your boxes except for the powertrain performance and fun to drive. It is fine to drive but fun would not be the way to describe it.
Subarus sometimes burn oil (about 10% or so) but if you watch the oil level they don't have any issues. I have a 2013 Legacy H6 engine that does just that, but I add oil and nothing else is an issue - now approaching 73,000.
Another car that may fit the bill - the 2016 Ford Focus RS. It also has a six speed manual and AWD. It is not as reliable as the above mentioned Subaru, but it does not have the oil consumption issues and it is not a bad car as far as that goes. Here is one near me (a 2017) with less than 10,000 on the odometer and going for $34,000 (a new one is more than $40,000).
Mini Cooper S Paceman All4 and VW Golf R 4Motion also fit your description but I would not recommend either as their reliablity is pretty bad.
The WRX and the Ford Focus R (used ones for price and the hatch) are your best bet to get you what you want. The other two options I mentioned are also viable but be aware you wil most likely have more issues with them as they age. The Crosstrek you probably won't like as it does not meet your performance needs.
Open to other thoughts on the board.... best of luck.