I've had blowers and they create more heat inside and especially outside the case.
I am bit confused what you meant here :- ).
Inside case? Blower cards don't create any heat inside case because they blow it outside.
Inside the GPU itself? Like running hotter? They do usually run slightly hotter and lot more louder. That is mostly issue in gaming with power spikes from heavy turbo boost. It's not uncommon to lower the power envelope by 10perc. (Quadro cards are already more conservative here, i.e 250W vs 300W+)
Just one note on heat, because I often see it on Reddit frequently: Hot card doesn't produce more heat. It produces the same amount of heat, it's only transfered outside faster. If the card is 300W, it will produce 300W of heat, regardless if it's 60c or 90c degree hot (voltage does change based on heat though).
AIO GPU (I only know about EVGA, and few AMDs, does anyone else make them?) is pretty good idea if you can place the radiator as exhaust, effectively making the card into more silent blower. But they're pretty expensive (judging from EVGA 3090, the AIO version is like 300+ more expensive...bit too much).
If you only use GPU for viewport and Optix denoising, none of it matters much since it has low GPU utilization.
I am big fan of Ampere Founder Edition cards from nVidia. They are semi-blower, the best of both worlds. It particularly works great for the massive 3090. The AIB can be slightly cooler but are worse for powerful CPUs cooled by air tower. Gamers don't need to care, but if you have 80c hot Threadripper, every bit of case air improvement flow helps.