You’re right, you have to look at dribbble with the right eye. It’s rife with unbuildable designs and simply poor execution. My design education gave me the right background so I can examine them a little more effectively and pick out which parts to try in my own work. As far as other resources, there are no good pattern libraries I’ve found for desktop (there are many but their examples are quite lackluster). The best one I’ve used consistently for mobile is: http://pttrns.com/.

In general the best inspiration for proper pattern usage is by looking at successful products. It’s not always the most inspiring but I find that if a product is successful, that means their implementation was buildable and if the product is popular, it means they may have established a convention worth emulating.