A perfect example of this is the Cannondale CAD3. It had a massive downtube and huge (straight) seat stays as well. It was extraordinarily stiff and terribly unpleasant to ride, for most. Cannondale improved that to some degree by using S-shaped seat stays on the CAAD4 making the frame a less-efficient conductor of vibrations.
Modern aluminum bikes use hydroformed tubes with optimized shapes and shouldn't really have these problems. Unless you're talking about something with an aluminum fork. That's just a cheap bike. Aluminum forks are terrible.
https://www.youtube.com/watch?v=4WpGsJKVhZY
Thank you. I kinda always wondered how bike frames were made. This is really cool.
Source : I've shortened a lot of forks.
As to what's rare, hell if I know. Aluminum forks are fairly common on low to mid-tier bikes and the cheap ones tend to suck.