To be clear, I think he's pretty good. I don't love that he scrambles so much and his passing game needs a lot of work. But he's definitely a good land. He's very fast, but more importantly, he's a very smart kid with a good head on his shoulders.
He's not technically a top 200 recruit. You're wrong on that. He's close, but not there. Also, I don't love the composite. I think standard wisdom is 247 is the best, followed by Rivals, and then ESPN. On 247, he's a 3 Star QB who's the #21 QB and unranked among players nationally. Rivals has him as a 3 Star QB who's the #27 QB and unranked among players nationally. ESPN has him as a 4 Star and the #3 dual threat. All together, that makes him a 4 Star top 250 recruit. But it's strange that ESPN has such a differing view of him. As far as I'm aware, 247 and Rivals have actually seen him play in person but ESPN has not. I suspect a large part of ESPN's ranking is based on Davis's dad. As for me, I think he's a 4 Star athlete, but not a 4 Star quarterback. I'd see him eventually becoming like a wildcat QB who plays a lot as a receiver as well (I think the current guys SCar has are better QBs).
That's misleading, but that's not how college recruiting works. Not all offers are committable. The big programs will give a kid an offer and say "Hey, we told this other guy before you we wanted him, but we'd love to have you if these other guys don't commit." I follow other teams' recruiting, and most of the teams you listed never pursued Davis at QB (as I said, he's a good athlete). Alabama and Clemson were going hard for Ty Simpson, and when Bama got him, Clemson flipped to Cade Klubnik. They never pursued Davis. A&M was always Weigman. They wanted Davis for WR. LSU was always for Walker Howard and Davis never had a committable offer. Same with Penn State and Allar. I don't know about Georgia (whether he ever had a committable offer), but I know they strongly preferred Stockton. Similarly, I went on the Auburn and FSU boards, and their fans never even discussed Davis for QB, focusing all on the guys they landed, who are ranked higher than Davis in 2 of the 3 services.
I do know that he had a committable offer from Arkansas, Georgia Tech, and Tennessee. Not a bad list at all. As I said, the kid's a great athlete. He may become a really good QB (he has the right mindset for it, which is the hardest thing to coach, he just needs to improve his strength/fundamentals). But his list of committable offers is tremendously different from the list you gave.
