I'm not an econometrician but here is my guide on some books I found helpful (and still do).
My opinion is that a nice place to start is with an advanced undergraduate textbook. These are often helpful even for postgraduate students to build intuition and brush up on mathematical techniques. For books at this level I would recommend Introductory Econometrics: A Modern Approach by Wooldridge, Introduction to Econometrics by Stock and Watson and Introduction to Econometrics by Dougherty.
You mention a dislike of maths and stats. Do you have much in the way of familiarity with matrix algebra? If not, I recommend A Guide to Modern Econometrics Verbeek and the older Econometric Methods by Johnston and DiNardo. These two books are pitched at the more basic end of the graduate level and have excellent appendices on matrix algebra. Either of these would be an excellent starting point for you.
More advanced books include Greene's Econometric Analysis and my favourite; Econometrics by Fumio Hayashi. The latter textbook centers on the Generalised Method of Moments as an organizing principle which really helps illuminate the material. Econometric Analysis of Cross Sectional and Pannel Data Wooldridge is a classic at the graduate level. It may also be worth considering the online textbook by Bruce Hansen. It's available on his website https://www.ssc.wisc.edu/~bhansen/econometrics/ These textbooks could be considered rather mathematical on the first reading. For example, the large sample properties of estimators require some sophisticated mathematical machinery. All the textbooks mentioned above give a fairly digestible but somewhat superficial treatment of these topics. To get a good understanding of these topics a course in measure theory and integration would be a great help!
After these come the more specialized books in Panel Data / Microeconometerics and Time Series. The books mentioned in the previous paragraph generally do have an introduction to these topics but it's rather limited. In terms of Time Series a great textbook is Applied Econometric Time Series by Walter Enders. This book is much more focused on Time Series in real world applications and is lighter on the technical details. I would recommend this to you if you're still interested in VAR, ARCH, GARCH and error correction models etc. In stark contrast is Time Series Analysis by James Hamilton. A very thorough textbook but quite a hard read. In terms of Microeconometrics, I like Microeconometrics by Cameron and Trivedi and Baltagi's Econometric Analysis of Panel Data. There are many, many more excellent textbooks in these fields but they're too numerous to mention. Remember, these books are advanced and would only be used once you've taken the standard grad econometrics courses.
Lastly, every economist should have a copy of Angrist and Pischke's Mostly Harmless Econometrics A great guide to econometrics as a discipline.