Idea Summary
I've often interacted with Front-End Developers for which APEX looked interesting. That is until they saw how much code a blank page actually generates. 

To make their life easier when creating full custom HTML pages we always create for them a blank page template and let them write the necessary code with one or multiple Static regions. 

Occasionally they need dynamic data and we once again go hack some Report or List templates to accommodate their needs.

It would be great if APEX could provide by default a Blank page which is actually Blank, as in NO HTML within the page body . The page would have a property called SQL source that would allow developers to input some SQL. 

That data from the SQL would then be used by the Front End Devs in their custom page just like we use the Advanced HTML section of a Cards Region. They could write their custom HTML and here and there make use of Template Directive Loops, Ifs and Case statements for dynamic data.