Well, I moved from living in flats and apartments both here and abroad, so owning even a small house has been a revelation for me! We have three bedrooms - the attic which is the biggest, main 1st floor bedroom and a third which is small, but not the tiniest box room I've ever seen. We have a cosy front room with a door that opens straight onto it, but we don't use the front door very much, most people round here use the back. The kitchen is large enough for a small dining table. The bathroom is very small and narrow but we have a bath in there (we are replacing it with a big shower). We have a little garden at the back which is all patio but we have a couple of mature trees and stuff. We have a big basement which is great for junk/storage, most round here have basements, some of which have been converted or have that potential for more space.
If you are coming from a larger type of house it will seem small, but you can get slightly bigger - look for extended properties, ones with converted basements or bigger gardens, or ones that have rooms over the ginnel. I agree I've seen a lot of lovely interiors on Rightmove recently (still get property alerts and I'm interested/nosey!) We have a an NHS worker couple next door, they work late shifts sometimes but are very quiet coming in and very pleasant. Retirees on the other side. Walls are very thick stone, can hear barely anything next door except when doors are banged accidentally. Next door once had friends round for a small party and you could hear a bit of loud drunken talking from one person. Can't hear normal talking or TV or stuff like that.
I'm personally not too bothered about Ecclesall, I think it's a bit overpriced, my DH's old boss lives there in one of the bigger Victorian villas and it's nice, good for more space but that's all really.
Walkley has a fair amount of students too, and there are definitely less students in Crookes now. I think the higher prices in Crookes are mainly down to school catchment.
Give us an update when you've looked around!