Enjoyment turning to frustration as the lack of ammo is killing me (literally) melee just does'nt go good as I can't tank the mobs.
Close range combat with weapons is shocking with the hit detection.
Need me a good source of lead.
I can tell you what I did to begin with. It worked for me - I soon built up to ~2000 rounds (~1000 for each of my weapons) and I easily maintain that amount unless I go full auto. I hardly ever used melee.
To start with, I picked up and scrapped every pipe weapon unless it was better than the one I already had (in which case I repaired and modded that one and scrapped my previous one) until I had all the mods for pipe guns and pipe revolver pistols (including a stock, which turns it into a rifle). Although by that time I had dispensed with pipe pistols and was using a pump-action shotgun (and scrapping every other one I found for the mods).
So by L5 (I think, maybe it was L10 for the shotgun), I was using a pipe revolver rifle for distance and a pump-action shotgun for close range. Both have quite slow rates of fire but high damage per shot, which reduces ammo use. Pipe revolver rifle with a hardened receiver, recoil reducing stock, stabilised long barrel and medium scope works well at a distance. For most mobs, aim for the head. Shotgun with similar mods but no scope (no use for one) works well at close range. Aim not really required. Favourite them both to make swapping between them easy.
I stayed in the valley area until I was at least L20. Mobs are much easier in that area and won't be way over your level.
I also scrapped all spare leather and metal armour to learn mods. Girded leather, for example, is much better than ordinary leather.
Once I had learned the plans for a weapon or armour, I crafted it at the maximum level I could, crafting new kit when possible. A L10 item is significantly better than a L1 item.
I picked perks for shotgun and rifle, which increase damage, increase stagger chance, whatever is useful.
I was using those weapons up to high 20s in level, when I finally learned enough combat shotgun and combat rifle mods to switch to those. I'm L39 and I still haven't learned how to craft a combat shotgun, nor have I learned how to craft a hardened receiver for a combat rifle. But it's still fine for soloing a L50 scorchbeast and half a dozen ~L30 scorched at the same time.
I assume you have lead tagged for search. It's rare enough if you do. If you don't, you'll probably end up missing most of it. Many items contain lead in the Fallout world. Children's toys. Paint. Pencils. All sorts of things.