To get the list of Visualforce Page which are defined with the standardController attribute, we can write SOQL query on ApexPage object with passing ControllerType field value Standard.

Sample SOQL:

SELECT Name, ApiVersion, ControllerKey, ControllerType, Description, NamespacePrefix, MasterLabel, CreatedDate FROM ApexPage Where ControllerType = 'Standard'