Sure, right, but

use MyFoo -macronic => <<'YO';
 ...
 YO;
[download]

???

What is that meant to prove or disprove?

All you've succeeded in doing is pass a multi-line string as an argument to a modules import list.

A (trivial) example macro might look something like this:

use Macro ADD( x, y ) {
   x + y;
}

...

my $p = getPfromSomewhere();
my $q = getQfromSomewhere();
my $r = ADD( $p, $q );
[download]

Which would substitute out as:

my $p = getPfromSomewhere();
my $q = getQfromSomewhere();
$r = $p + $q;
[download]

And better yet:

use Macro ADD( x, y ) {
   x + y;
}

...

my $r = ADD( getPfromSomewhere(), getQfromSomewhere() );
...
my $s = ADD( geta(), getb() );
[download]

Resulting in just:

my $r = getPfromSomewhere() + getQfromSomewhere();
my $s = geta() + getb();
[download]

Allowing the efficient use of small "functions and methods" at the source level without the runtime overhead of the calls.