I would like to have a Report fucntion which can display all the User Posts related to Opportuniti Entity and Appointment Entity.

Currently, users can find in 'What's new' section to see if there are any Posts related to the record in Sales Activity Social Dashboard.
But, it would be a lot better if you can just view the User Posts about specific entities and manage in your View or Report.