I believe "indexes with only one column" does not reveal all the indexes we need to see.

Clustered indexes with 1st column of uniqueidentifier type are as bad, probably even worse.

Following version of the script reveals all "bad" clustered indexes:

select object_name(i.object_id) [object name], i.name [index name], c.name [UID column name]

from sys.indexes i

inner join sys.index_columns ic ON i.object_id = ic.object_id and i.index_id = ic.index_id AND index_column_id = 1

inner join sys.columns c on ic.object_id = c.object_id and ic.column_id = c.column_id

inner join sys.types t on c.user_type_id = t.user_type_id AND t.name = N'uniqueidentifier'

where i.object_id > 1000 -- no system objects

and i.type = 1 -- clustered

order by 1,2;