I would definitely buy a manual if I could. Just more fun to drive. I think Honda civic’s lowest model might still have one. Not sure of anything else.
For some cars are a hobby, but for many people they’re most another tool in our lives.
If I commuted to an office every day I’d get an auto (actually these days an EV), but working in the bush/backroads? Manual
As it is I don’t deal with traffic so a manual is a more fun “tool” to drive.
Hard to find this in any current cars, especially affordable ones.
If you want a crossover I think the only new one that still has a manual is the Crosstrek.