LINQ is far from wonky, it's essentially just a bunch of lambdas built to create execution trees which can be optimised then converted to e.g. SQL.
it's powerful and using typed-compile-time-checked LINQ for building DB queries is far superior as a developer experience than some monolithic blocks of SQL text and a test suite.
asp.net5 is getting pretty decent (and close to release) so for current projects I use c# to host my API and bootstrap the app up, but all the frontends are modern js frameworks (using typescript) rather than MS MVC.