Also, I am unsure about why any of these SEO solutions insist on putting the ID in the URL. What is the point if customers use unique product names? Does it have something to do with 301 Redirect?

I like Ultimate SEO because it uses product names without any category in the URL. And it looks like if hacked, the pID can be removed. But uSEO's support looks to be abandoned and needed improvements appear unlikely.