LOL love the revving analogy as I am a dirt bike rider (2 stoke) and and see people do that all the time in the bike unloading area...they love the rev limiter sound, my ears bleed!
I got an i5 6600k (the 'k' means over-clockable) CPU for my last build but haven't bothered with OC for reasons you stated and it runs fast and fine in stock trim, low temps power draw etc.
As far as I know most modern CPU's motherboards GPU's etc have 'thermal protection' built into them so would likely throttle back or shutdown way before doing any damage, just like engines have rev limiters, so the manufacturer can 'protect' themselves from litigation bad reputation/bad press, fan failures and the like.
My hardware was all 10+ years old before the i5 build so it felt like a rocket to use in comparison, puts a smile on your dial for a while. I was going to make it an AMD build but Ryzen wasn't quiet out at the time and the old AM3+ platform had no upgrade future so went Intel/Nvidia.
I hear lots of good things about Ryzen and AMD in general so Intel has someone keeping them honest (Gough Gough). Intel has had it their own way for a long time and become greedy along with Nvidia, hopefully prices might come down more as a result, might be good time for cheap GPU with all the crypto miners selling due to low crypto prices?
Building PC's is such an interesting thing to do, with most things you just pick the manufacturer options as they see fit, petrol / diesel auto / manual for cars, maybe screen size and some sound options for a tv, the colour for a toaster but you can mix and match so many options (almost too many), then build it yourself, upgrade it later on and even break it if you want!
Anyway have fun with the rest of your build process and looking forward to seeing more pics and info as you go.
BTW I posted my build and pics on PC part picker website some time ago if your interested, here:
https://au.pcpartpicker.com/b/rtccCJ