Warn on boolean frame indexer
- [ ] closes #39004
- [ ] tests added / passed
- [ ] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [ ] whatsnew entry

- Is it ok to check index/column to allow things like df[df > 0] or should I just warn on DataFrame in general?
- Can I do the same thing for `setitem` as well?

Current version warns in 3 already existing tests:
- pandas/tests/frame/indexing/test_where.py::TestDataFrameIndexingWhere::test_where_datetime
- pandas/tests/frame/test_nonunique_indexes.py::TestDataFrameNonuniqueIndexes::test_getitem_boolean_frame_unaligned_with_duplicate_columns
- pandas/tests/indexing/test_indexing.py::TestMisc::test_partial_boolean_frame_indexing