> Shouldn’t the results I get from a paid service at least be better than a bad StackOverflow suggestion that got down-voted to the bottom of the page (and which would probably come with additional comments and suggestions letting me know why it was ranked lower)?

I don't know why you would expect this, when the model is likely trained on StackOverflow material (or similar publicly available code examples).