This seems like something an LLM would be good at but probably not cost effective for most use cases.
Discussion
Maybe some pre-defined scale would be simpler, and less expensive
Check this out: https://kt.ijs.si/data/Emoji_sentiment_ranking/
Also relevant: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4671607/