Simple views are perfectly fine - it's mostly nesting of views with aggregate functions and other complicated stuff that is bad.
And if ad-hoc is a big part of what users are doing with an app/database and you don't care about performance, your angle sounds reasonable.
As an app developer/development DBA, I care mostly about performance of the queries that are known at development time, though, so I'm a bit biased.
