There are plenty of programming languages out there, as you all may know. I am primarily looking for a list of programming languages WITH some very neat proof of concepts. I would really like to learn a new language, but whenever I dive into something new and popular, it isn't what I expected. Any tutorial out there will give you code, small examples, but won't show you the true power of the language. I am looking for examples that run entirely on the language that it is exemplifying.
For example, If I said C#, I could possibly show you a complete C# app with backend queries, reports, tables, all with a nice interface. The end program/app would be completely reliant on the language that is provided, so no side-by-side languages. I understand that most languages are integrated with other languages in order to provide a richer application.
Any links, charts, websites that may reflect this request is appreciated.