DeFi Pulse is the trusted go-to source for DeFi data on project usage and (TVL) Total Value Locked. Their homepage has a leaderboard with the most actively used DeFi protocols spanning various categories and Blockchains.
You might also enjoy browsing through "The DeFi List" which explains and categorizes all the DeFi projects and protocols you need to know about.
- DeFi Pulse