When should I not use Views for listing content?
That's quite a subjective question, but generally speaking, use Views if


You need it done quickly
You need to allow flexible UI edit access
You don't mind a slight performance hit
You need Views for some other module integration ( VBO, views_data_export etc.. )


Otherwise, you can use custom page callbacks


If you don't mind taking a bit longer to build
You don't need UI edit access
You want the fastest performance.
You want to do something Views can't do, or that is much easier to do custom.
You are a capable developer.