There's a guy near me that collects yard equipment with small engines, rebuilds them, and sells them for minimal costs over what he puts into them. I think he looks at it as a way to keep things out of the landfill and help people out more than a way to make money.
I do some woodworking and there's a lot of small stuff that you can do with just hand tools in a limited space without being too loud or making too much mess. A basic setup would be a saw, some chisels, a plane, maybe some sandpaper, and of course wood. Some sort of workbench helps. Clamps are nice. Glue can help if your joinery isn't great. I'm very much an amateur, but I enjoy it. And I enjoy the fruits of my labor, even if they aren't always beautiful. It'll get there with time.
If there's a maker space in your area, they tend to have well outfitted shops to work in where you could give any number of things a try for a month's membership.