Whether or not one regards a United States President as "great" will depend on the criteria used. What those criteria are is subjective.
For example, one may regard President William J. Clinton as a "great" president if any of these criteria are used to determine "great."
1. Has first name, "William."
2. Has middle initial "J."
3. Has last name, "Clinton."
4. Was a state governor prior to becoming President
5. Has a brother who is also an
absolute train wreck of a convicted felon who required a Presidential pardon from his brother.
6. Has mother named, "Virginia."
7. Is a parent.
Seems to me that, upon direct comparison, utilizing the parameters you set forth, GWB should be considered, at the very least,
vastly superior to Clinton by anyone with anything resembling a logical mind.
In my analysis, I'd say the separating factor is definitely, um, #5 and the differences between a drug abusing, alcoholic felon and a successful and popular state governor are, well,
stark.
Not that this outcome is anything terribly surprising to me, of course.
Always glad to meet another GWB fan!

. Welcome aboard!