DCS: Black Shark and DCS: A-10C for sick air to ground flight sims. Many other sims have air to ground obviously, but these two focus very specifically on air to ground aircraft, so they're pretty much what you want in the sim department. Modern. If you get either send me a PM, we will jump start Codex flight squad and it will be fun. Il-2 was also mentioned, it does feature a lot of bombers, so. That too. Or really just look at any of the billions of sims I haven't played, most of them will have bombs.
Combat Mission: Shock Force features airstrikes, though they can be effective and important they're not totally awesome or visually stunning. Don't know if this is what you want. Tactical, either real-time or phase based. Modern.
Achtung Panzer! Kharkov 1943 has Stukas and Sturmoviks. Tactical, real time, with a turn based operational element. Aircraft are not omnipresent but can be extremely effective. Huge fan of this game.
Steel Fury: Kharkov 1942 is a real time tank simulator that allows you some very basic tactical control over subordinates, including air strikes.
Panzer Command series features bombers. Tactical, phase based like Combat Mission. WW2.
Steel Panthers has aircraft. Awesome, classic, turn based, WW2.
I guess Panzer General? People seem to like that, but meh. I don't think it'd scratch the itch you have very well.
Armored Brigade is a real time tactical level simulator with a very heavy emphasis on realism. Aircraft are naturally involved. Late Cold War.
Fleet Command is a modern real time fleet simulator. That of course involves carriers which then involve aircraft. Very big air element here. You will shoot many missiles at many things. As I understand it, may be simple compared to Harpoon. Never played Harpoon so I can't tell you. Prob check that out too.
If you wanted STRATEGY strategy, not ridiculous RTS crap, aircraft naturally play a huge role in the Hearts of Iron series. Also, pretty much any operational war game from WW2 on. Just pick one. Though I'm not sure this is exactly what you're looking for.
Operation Flashpoint, Arma and Arma 2 feature basic flight simulation. It's simplified to the point of being ridiculous, but the aircraft are very effective and are therefore a huge force when involved in a mission. I think they're generally underutilized by most mission makers, but there's definitely been some great missions involving aircraft. Also send me a PM if you get this and want to become a pilot type.
Currently can't think of anything else that really has the player involved with the aircraft/is good. If I do, I'll edit.