Yes, an aluminum frame can be made to flex but about 90% of the aluminum frames are built to be stiff to hedge against breakage. Your racing frame reasoning for using stiff tubes is not correct, there are lots of low end aluminum frames, such as for kids bikes, and most have large diameter stiff tubes.

And I'm not waiving my engineering degree around. Fat Boy asked if I was an engineer and I answered.