The weightage of the essay paper in the overall scoring of the UPSC Mains Examination can vary but typically ranges around 250 marks. Since it assesses candidates' ability to present coherent arguments and elaborate on given topics, performing well in the essay section can significantly impact the final score, making it a critical component of the evaluation process.