Seems like he is a bit lost in terms of what he can do or not knowing his skills.
Maybe you are looking for what could be right for you:
Throwing some ideas for you and feel free to add:
Creative at all? Web design, try putting something together using these easy page builders, i.e Elementor (free). Setup a local Wordpress, using Flywheel (Local) and install Elementor and watch heaps of videos out there.
VideoScribe tool, (trial exist) create as a test an some animation / explainer. Piss easy. Or even try Brizy Cloud as an alt to Elementor for those that need fast and quick html static landing pages.
You develop or starting, do something to automate tasks for some local business that needs some automation instead of them doing the data entry by hand. Have a play with BAS - Browser Automation Studio - that is free and see what you can come up with.
Excel, build some skills in excel, doing some VBA/ Macros for local business to automation excel tasks. Visit local businesses and see what they may need help with. Even create a gig on freelance marketplaces.
Lots more ideas, but give us some clues for direction at least.