For background: power output is basically torque * RPM, and for the most part, torque is about what you do with the accelerator pedal.
High RPM means more mechanical friction (oil films are experiencing higher rate of viscous shear, therefore higher shear stress, therefore more frictive force), which means less efficiency.
Light load (low torque) also means low efficiency, because A) you’re not making much power compared to all the RPM-related friction, and B) you’re consuming extra power to suck intake air past a mostly-closed throttle plate (the lack of any throttle plate at all is an important part of why diesel engines have good part-load efficiency).
So if you want good fuel economy, and you have a choice between light load+high RPM and high load+low RPM, choose the latter, but don’t take it to an extreme. Running an engine at very high load and very low RPM is probably worse for it than the opposite: now you’re dealing with very high cylinder pressures and temperatures, which puts high loads on the piston rings and skirts and really cooks things. If you have a car with an automatic transmission, then you know that this is exactly what the car does, i.e. it generally picks the highest cruising gear it can pick without lugging the engine, in order to maximize fuel economy.
It’s worth noting, too, that if you live in a mountainous region, you’re probably operating at significant altitude, and so (assuming no turbo) it’s not even possible to heavily load the engine. If you’re in Denver, your engine can only make about 85% of its sea-level rated torque; if you’re at the summit of Pikes Peak, it’s only good for 60%. (Want a slow ride? Take a Prius up Pikes Peak. The electric propulsion will be useless on such a long climb, leaving you with just 60 horsepower of internal combustion by the time you get to the summit. Don’t count on passing anyone.) So even if you’ve got your right foot down pretty far during your grade climbs, you’re probably still not taxing the engine as hard as you might think.
As far as rev-related beating on your engine is concerned, 4000-5000 RPM for a redline is 6500 isn’t a huge problem. It may cause a little extra wear, but really not much at all, and in the context of the entire life of the car, very little since you only spend a tiny % of the car’s life under these operating conditions. Change your oil regularly, avoid buying the cheapest/shittiest oil you can find, and try not to take a whole lot of very short trips (<5-10 miles), and your engine should provide you with a pretty normal service life.