No — "and" is lowercase in the middle of a title in most style guides.
"And" is a coordinating conjunction and stays lowercase in the middle of a title in AP Style, Chicago Style, MLA Style, NYT Style, and AMA Style. It is capitalized only in Billboard Style or when it opens or closes a title.
The rationale is that coordinating conjunctions function as connectors rather than meaning-bearing content words. Style guides reserve capitalization for words like nouns, verbs, adjectives, and adverbs that carry the substantive content of a title.
When "and" appears as the first word of a title, it is always capitalized. This is an unusual position for "and," but it occurs in titles that begin with a list continuation or a deliberate stylistic choice.
Billboard Style is the primary exception, capitalizing every word including "and." This convention is common in album covers, song titles, and advertising headlines where visual density and emphasis are priorities.
"And" is one of the seven coordinating conjunctions covered by the acronym FANBOYS: for, and, nor, but, or, yet, so. All seven are consistently lowercased in the middle of a title by AP Style, Chicago Style, MLA Style, NYT Style, and AMA Style.