You may or may not be an exceptional transmission driver but you have the wrong impression when it comes to newer cars. You attitude is a holdover from when automatic transmissions were new and both not as reliable and not as ‘smart’ as they are today. With manual transmissions, you are generally going to have clutch problems at about the 100K mileage mark unless you are exceptionally careful. A bad manual transmission driver can destroy a clutch in less than 20K miles.
A clutch replacement is going to cost anywhere from a few hundred dollars to well over a thousand dollars. OTOH, automatic transmissions on reputable models can easily go well over the 200K mileage point today with no issues. Some other part of the vehicle usually fails or someone totals the car before the transmission becomes an issue. More likely, the owner just gets tired of it and buys a new car before transmission issues are a factor.
Furthermore, there is a general fallacy among some drivers especially European ones that manual transmissions are superior because of gas mileage, performance or general driver control. That was true at one point but it isn’t nearly as true today and many of those considerations have been reversed because of electronic technology. You may not like it but the computer can always beat you when it comes to optimized shift points, traction control, and braking strategy today. This isn’t 1985 any more.
To prove a point, I sometimes like to challenge people in old muscle cars to an impromptu drag race at red light sometimes. They have something like their souped up 1969 Camaro with custom manual shift and I have my 2010 Toyota Rav4 Sport with an automatic transmission and traction control. None of them have ever come close to beating me and mine is a stock family wagon that gets great gas mileage on the highway.
I don’t mean to be insulting but you don’t sound very knowledgeable about how automobile technology has progressed in the last 30 years. It is phenomenal to say the least. Even the mid-range brands are safer, more fuel efficient, much more powerful, and generally more luxurious than the older ones for roughly the same price as the older ones when adjusted for inflation.
If you still don’t want any part of that, buy a restored model from the past. My first car was a 1989 Mazda B2000 pickup truck that meets all of your criteria except it has an air conditioner and it still exists. It has 80hp and was a bitch to drive in bad conditions but you would probably love it. I could have that thing fixed up to pristine for you for a few thousand dollars. It doesn’t even have a stock radio. Perfect!