The TeX font catalogue doesn't allow you to see which fonts have real small caps. Some fonts do not have real small caps (e.g. any of the
mathdesign ones). But some do (computer modern and therefore
I have restricted this to fonts that come with TeXLive, but I guess answers about other standard LaTeX distributions (MikTeX etc) wouldn't be out of place.