Actually, hyperspeed uses no more fuel than regular, but provides 10x speed. The offset is the added cost of the engine and the added size, 2x larger at base tech. If you go the usual 10% devotion to engine, then your ships suddenly become 20% engine using base tech. The end of hyper efficiency research gives 1x size, but still suffers the added resource and research cost. The other offset is that it can only be used in the outer solar system, and if you're caught in inner then you're suffering for your large engine = less firepower.
Still, your delicate ships could probably utilize some hyper, like your carrier is probably sitting outside hyper and has no armor to protect itself, so a hyper engine to let it flee from enemies quickly could save you from a world of hurt. My own logistics ships get 1/2 engine count but get hyper engines. They move slower normally, but outside hyper they can run quickly. These are the ships mounted with thousands of maintenance supplies and millions of gallons of fuel, plus whatever magazines and additional hangars for extra fighters might be needed. They're behemoth capital ships, but unarmored and only mounting some big-ass passive sensors, with the intended role to sit 1-2 systems back and provide after-combat repair and rearming. Utilizing waypoints and nearby planets, I get them across systems very fast, and they can outrun most threats due to the hyperdrive. Fighters can prove a hassle, but the ship is usually carrying spare fighters that didn't fit in the battle group, or gets a handful of AMM that work well enough. Plus it's usually escorted by a handful of corvettes for very basic defense.