Never fly before testing everything, I said to arm test it, not fly it. Arm testing is to set up the arm and disarm ONLY, then you progress to hovering. That way if it takes off you disarm straight away and it drops.
You can set up a beeper to find your quad, I know it’s a bit late now but something to think about for when you find it. Keep looking, it could be much further out than you think.
If you are considering buying another pre made DO NOT do anything before backing up the whole stock tune and setting up arm/disarm, beeper, modes and crash flip on Betaflight. I would also consider a smaller and cheaper micro drone like the Sailfly or similar that is cheap to buy but fun to fly. That way you have less to lose in learning, or get in some sim time.
Fly aways like you had today can always be avoided if you go SLOWLY in learning. Get everything working reliably first, then start by only hovering. If anything happens DISARM IMMEDIATELY. That way it just drops to the floor and can be recovered. Flying with an observer is a good idea too. They can watch your drone and look out for hazards you might not see in the goggles.
Spin on arm is normal, you want that to tell you it’s armed and to keep back. I always keep that on.
I lost my first quad, it was a horrible experience, sorry to hear you had that problem. Keep looking!