How do I know if a vendor’s ERP consulting services are actually good, versus just good at sales?

Ask for client references, ask what a typical support ticket resolution looks like, and pay attention to whether they ask you detailed questions about your business, or just push their standard package regardless of what you describe.