I haven't seen a reply from OP. No clue on price range or other wants/needs.
You can get an Accord up to I think '20 or '21 in manual. I have a '17 Accord LX 6MT. One nice thing is that it also has a slight delay hill hold for the brakes. Helps with those learning or not quicker on hills. My kids learned to drive stick in my '07 Sonata 5MT. The drive by wire on that was not great. I used to stall randomly, it was very weird, I've been driving stick over 40 years.
The Accord is great. 2.4L non turbo, room for 4 comfortably, gets over 30mpg average and up to 40 highway. I can go almost 600 miles on a tank on trips. Both my kids said the Accord is MUCH easier to drive and learn stick as compared to old Sonata. My son steals it for trips all the time.
Granted Accord is more boring and not high powered BUT if new driver great to learn on also. Civics are good also. My kids (and everyone) wants new high power sporty until insurance and reality. Older Mazda CX-5's came in stick also I think to 2015. I like the small SUV's for sitting higher visibility, AWD is a bonus if needed. My FWD cars with winter tires went places AWD on all seasons didn't. Ground clearance being the issue.
For OP- look at
STREETSURVIVAL.ORG for skills also, highly recommended. I have other posts with links to my google pictures/videos. You use the car they will drive on wet skid pad, emergency braking (ABS), emergency lane change etc. Not your regular drivers ed class. My son did it in the 5MT Sonata with and without stability control on. He and his GF did it in the hand me down CRV. My daughter did it in her CRV. Beats the tires a bit but those are easy to replace.
The other thing to think is where they are driving with other new kids. My son's old CRV and his current 2010 Forte have many little scratches/scuffs on the corners and doors. All induced by others while sitting in high school and more from college parking lots. When you don't pay a lot and expect it from newer drivers, it doesn't bother you as much. Keep them clean, maintained and personalize with some nicer (not expensive) rims, good tires, maybe tint and tunes. When all becomes better skilled or more money, rock on.
Teach them safety and always seatbelts for all even in the back. This was last week at my daughters school.
Sacred Heart Crash kid in the S8 convertible was always speeding on campus, showing off and posting social media attitudes from what I saw. 2 girls in the Uber went through the windshield. Really eye awakening. The 2 videos I got are disturbing and I drive an ambulance and respond to these things.