Just playing around on the streets in those RPM ranges for a minute or two is no big deal.
^ this. Your brakes will fail looong before before the engine does.
Well it's not a boat engine which is specifically designed for reliable operation of continuous high RPM.
Mine turns >2500 RPM all the time except when stopped at a light. >3500 is where the meat starts.
As long as you keep the oil and coolant temp under control, a fairly long time. They actually have more issues getting real hot and then immediately being brought down to an idle and sitting for a while. Some companies make engine coolant crossovers on the back of the engine to help alleviate this issue. Any time you put some real heat in it, it's a good idea to do some cooldown passes afterwards if you don't have this mod. Ultimately, these engines are not endurance engines like you'd see in Le Mans or other endurance type races, but a lot of that comes down to what provisions the engine has to keep oil pressure up, oil temp between 210-280 F, and the engine coolant temp consistent. Those 3 things really determine when that engine fails, as long as the engine has stout parts that don't fail from metal fatigue or something else along those lines.
Pretty much what everyone else is saying. Engine will be fine but you'll incur more wear quicker and have to do maintenance in shorter intervals (oil changes/coolant, etc). You mentioned tuning your previous vehicle. Ford performance has a tune that will increase low end torque by 40 @ 2000 rpm (and add 19 HP but you'll be restricted to 91 and above octane) and it will still be warrantied for 3 yrs from when you purchased the vehicle. That can be an option if you want more low end oomph.
If you had bought a Camaro or Challenger, you'd feel more low down torque. Regardless, the 5.0L still produces 420lb-ft which is nothing to sneeze at...a lot more than a Miata. A turbo WRX - not sure, but turbos usually increase low down torque. Driving an F-150 with the 5.0 vs either of the EcoBoost makes the V8 feel flat off the line. But around 4k this engine is very strong.
I can't speak to what Miatas want from any recent small-bore 4 experience, but small-displacement NA engines do need to get some revs showing before much happens. I once built a 7500 rpm 2.0L OHC Ford motor that started to wake up at a little over 3200 rpm.
That and subarus are NOTORIOUS for having terribly designed oil pans. High G situations have been known to let the pickup run dry, followed by spun bearings a moment later
Sorry but I would question the question.