What state should I be in when bestowing prayers upon the Prophet ﷺ ?

While doing so you should witness the exalted nature of the Prophet ﷺ and long to be with him in the next life. Be conscious that in reality it is not you who is bestowing prayers upon him but Allah and also that the Prophet does not need your prayers but rather you need the benefits that it contains.