I agree with Felicity Cloake, where she compares other people's recipes after testing them and makes recommendations.
Otherwise my go to is Darina Allen's Ballymaloe Cookery Course book, you can get it at a good price second hand online. I like books which explain the science behind what you're trying to achieve and why the process works the way it does. It's an excellent kitchen bible so to speak.
Totally agree that flavourful dishes, as opposed to flavoursome ingredients, contain heaps more butter, good quality oil and seasoning than you'd ever imagine in most domestic kitchens. It's also true that sticking to seasonal, local if you can get them, ingredients gives you much better flavours than imported.
Some always availables in my kitchen are
Roasting bags for chicken. I stuff the cavity and around the seasoned bird with herbs and citrus chunks and keep the jelly for stock.
Roasted heads of garlic in the fridge. Put a head of garlic in tinfoil inside a small ramekin type dish to fit, cover with drizzles of oil, close foil and roast while something else is cooking. You use the roasted garlic as a paste that squeezes out of each clove. It's a great flavour, but less of a sharp edge than raw garlic added to a dish.
Similarly I keep roasted sweet peppers in the fridge in the oil they were cooked in. Very handy to have by you.
As I said before, make in advance and let flavours develop, curries and casseroles and that aubergine dish above in particular.
A tip for cooking aubergines was a Barefoot Contessa method of stabbing a whole aubergine all the way up and down and around, with a fork and massaging it with olive oil before putting in the oven. They always need a lot more cooking than recipes would have you believe.
Finally, for now, take inspiration from dishes you see in the supermarket. I make my own tomato and vodka sauce for pasta after seeing it on sale commercially. I also follow Instagram cooks and chefs and cherry pick what to do that they demonstrate. Julius Roberts is one favourite and Nancy Birtwhistle has inspired me to make my own stock cubes.
Obviously not everyone has the time or inclination to make stock cubes etc. but once you get into your stride and accept you get some wins and some fails, you feel much more confident to give things a go or adjust the recipes you follow to your own taste.