While creating stored procedures, it is imperative you name them intuitively corresponding to the process they do.
I have learnt that a good naming convention really makes it easy to find the stored procedure you are looking for and for other team of developers to debug, modify or extend your existing stored procedures.
Needless to say, good naming convention is also best practice in software development process.
Here is how I like or prefer to follow
Here is an example,
Another common practice is to add sp (stored procedure) or something bespoke instead in the front, followed by object and then full action name for instance,
I suppose the best way is to have a naming convention than to not have one.