Indeed, if you want to see what is possible with only a Famicom (or NES) itself you can have a look at Little Limit's incredible Bad Apple "port" [1]. This recording is from an emulator [2], but I know from personal experience that it plays perfectly fine on my "New Famicom" (HVC-101). This is not to detract from how amazing the posted ACE is, but it is indeed different in terms of data limitations.
[1]: https://littlelimit.net/bad_apple_2_5.htm
[2]: https://www.youtube.com/watch?v=eNU1lzr_m4Q