It’s really difficult to find hard academic researched books rather than pop histories, especially in places like public libraries. Are there any sort of lists of scholarly works out there I can look for books from?
There isn't a single database for academic works -- even academic databases/search engines such as JSTOR aren't comprehensive. Happily, booklists exist, including the AskHistorians booklist (although ours does mix pop and academic sources).
One thing you might consider doing is searching for comprehensive exam lists -- these are usually lists that colleges and universities generate for people studying for graduate degrees, which require (as the title implies) comprehensive examinations of knowledge in an area. These require a bit of Google-fu, but if there's a particular area you're interested in, you're welcome to ask a more specific question here.
Unfortunately there is no centralized database. And I do agree that many public libraries do a bad job of segregating academic work from non-academic work. I would advise a few things.
This is a lot of information! But I thought it might be helpful to you. Feel free to ask me any questions. As you might see by my suggestions, I mostly know German and European History, so I'm not much good outside of that.
The AHR, or American Historical Review is a fantastic journal that publishes articles on a variety of topics. Typicially they are based on chapters of upcoming books, or portions of PhD dissertations. They also review works as well as films, which is a great way to get some oversight and critique of modern scholarship. I am a PhD candidate in Modern European History, but I can ask professors in my dept if you can let me know an area of interest that is beyond my scope.