Replacing Ceiling Fan with Light Fixture - No Wall Switch
You've got many choices. There are pull chain fixtures, Smart fixtures, Smart bulbs for a regular fixture or standard fixtures with a remote control similar to the one pictured below from Amazon