I want to use Filebeat to read from a directory to ingest the log files, then to delete (sinkhole) the files once read and ingested into Elasticsearch. Is this achievable with Filebeat?
Welcome to our community! 
Filebeat is not currently able to do that unfortunately.
Logstash can, as mentioned here File input plugin | Logstash Reference [7.14] | Elastic